The ConnectionString property has not been initialized.

[robert201]

Hello,

VS 2005 + SQL 2005

This works:
[codee]connectionString="server = steve01\sqlexpress; database = servicemasterTEST; user id = sa; pwd="[/code]

This does not:

connectionString="server = steve01\sqlexpress; database = servicemasterTEST; trusted_connection = yes"

This also doesn't work:

connectionString="server = steve01\sqlexpress; database = servicemasterTEST; integrated security = true"

The connection string is located in the web.config file as tihs is a connection string for a web service.

I have been to

http://www.connectionstrings.com

and looked and tried them as well.

I can't userstand why it would let me use the user name and password but not the windows authenication.

I have started sql server management studio and entered for both sql authenication and also for windows authentication. Both of them work in sql server management studio.

I have check sql server to see if it running, and also set it for local and remote.

<authentication mode="Windows"/>
<identity impersonate = "true" />

Could it be that the asp.net user account has not been added to the sql server database? If this is so, can someone explain how to add it.

I have also added the above to the web.config file.

Can anyone tell me if I am missing something simple here.

Many thanks,

Steve

 

[mrdenny]

Is the web site running under the anomyous account, or are you running under basic authentication, or integrated authentication?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com