May 7, 2003 at 12:18 am
Hello
I am having trouble with my connection string on MSDE.The error message l keep on getting is
Sql server does not exist or access denied
The connections string l have tried are as follows:
Dim objConnection as New SqlClient.SqlConnection("Server = steves-pc; Database = keepfit; User ID = steves-pc\netsdk; Pwd =; trusted_ connection = false")
and l have also tried the following
Dim objConnection as New SqlClient.SqlConnection("Server = steves-pc; Database = keepfit; Trusted_Connection = True")
One question l have, is that l do l need to supply a password, as l don't know of any password that l can use.
Many thanks in advance
I don't have enterprise manager, is there another way to set up a ASPNET login, as l think that could be a problem
Many thanks in advance
May 7, 2003 at 8:05 am
Read this KB articles.
http://support.microsoft.com/default.aspx?scid=kb;en-us;316989
http://support.microsoft.com/default.aspx?scid=kb;en-us;815154
Edited by - Allen_Cui on 05/07/2003 08:05:49 AM
May 7, 2003 at 8:54 am
Hello
Thanks for you reply, and giving me the web site to go to. But l am still a bit lost. Could you give me a example connection string that l can use to get a connection using MSDE.
Thanks for your help
Steve
May 7, 2003 at 9:32 am
See example in the link below.
http://www.asp.net/Tutorials/quickstart.aspx and click 'Server-Side Data Access' on left panel.
Edited by - Allen_Cui on 05/07/2003 09:34:37 AM
May 7, 2003 at 11:30 pm
I'm getting the same error and its driving me crazy. Before I updated to sql2000 sp3 and framework 1.1, I didn't have any problems but now I can't get it to log into the server.
Sorry i'm not any help but at least this will help keep this topic up top for some guru to buzz in.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply