SQL Server, IIS6,, C#

By bkwdsarkie ·
getting system.ArgumentException format of initialization string does not conform to specification - enclosed is my connection string
<add name="MYDBConnectionString" providerName="System.Data.SqlClient" connectionString="Data Source=Servernamehere;Initial Catalog=MYDBName;Integrated Security=SSPI;Asynchronous Processing=True;TrustServerCertificate=true;MultipleActiveResultSets=True;Connect Timeout=30;Encrypt=True;Packet Size=16384"/>
My IIS6 is trying to run SSL - I'm new to, c# and SQL Server. Trying to get an application someone else built running.
Any help would greatly be appreciated.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Conn String

by Shellbot In reply to SQL Server, IIS6, ...

Post your connection string..(star out the password if want)

its possibly problem with your string, or could be how its initiallised..

Collapse -

Got the connection string thing fixed but...

by bkwdsarkie In reply to Conn String

Got the connection string fixed by changing the provider in in the iis6 configuration to my connectionstring that I was passing. But now the NT Authority that is running SQL is showing up on my default page as the logged in person instead of the Windows Identity of the user. What could cause this? Have CaC enabled IIS6 and it is prompting for my Cac pin but still showing NT Authority

Collapse -

Additional info on login displaying

by bkwdsarkie In reply to Got the connection string ...

In masterpage.master.cs supposed to be getting the windows login with this line
lbUserLoginID.text = "Logged In as: " + WindowsIdentity.GetCurrent().Name.ToString();
But the user is displaying as NT Authority\NETWORK SERVICE instead of the user. Have IIS6 CaC enabled and the app is prompting for the user's CaC id pin. When the wrong pin is entered the access to the web page fails. When the pin is entered correctly the front page of the app comes up but without the proper authority of the logged in user. Any ideas to correct this?

Collapse -

Way to early

by Shellbot In reply to Additional info on login ...

in the morning for me to be reading this..

this is a bit beyond me now..don't do that level of web dev.. short, I've no answer for ya on that one!

Anyone else???

Collapse -

Check this:

by Shellbot In reply to Got the connection string ...

asked someone who might know..they busy but gave me this:

lbUserLoginID.text = "Logged In as: " + HttpContext.Current.User.Name;

Collapse -

thanks for the different way to pull the user's id

by bkwdsarkie In reply to Check this:

but I believe that the trouble is in the SQL Server back-end. I'm database literate in Sybase, Oracle, and others but not too much with SQL Server, ASP.NET etc. I'll try the concept but still have to get the permissions to the dB and I think that is what I'm lacking.

Collapse -


by Shellbot In reply to thanks for the different ...

i hear ya..

so..does your application have a SQL login and permissions?
and do your users then have approriate logins/permissions?

Collapse -

Users have been granted roles

by bkwdsarkie In reply to ok

My application comes up to the main screen and shows my login, but the application tabs do not appear like I do not have permissions to the database. It is madening. Don't know what is not working.

Collapse -


by Shellbot In reply to Users have been granted r ...

it could be a lot of things..

its really hard to say when cannot see your code and what settings ect...

you debugging? whats it saying?

Collapse -


by Shellbot In reply to Users have been granted r ...

what kind of roles / permissions?

Related Discussions

Related Forums