|
-
July 12th, 2005, 08:49 AM
#1
SQL Server Connection
I know that this has been covered over and over again, but I've read through the posts on this site and I still can't figure out my problem.
I am trying to establish an sql connection to an instance running on my local. I have both SQL Server 2000 and MSDE running. I didn't set all of it up well, however, and this is adding to my confusion. The server that MSDE says is running bears the same name as my machine (MARK-HARLEY). When I open the Enterprise Manager, my db lies under:
Console Root->Microsoft SQL Servers->Mark->MARK-HARLEY
I have set up the db itself and added a user with the correct permissions. My problem is that I get the following error when I run the program and attempt to connect to the db:
SQL Server does not exist or access denied.
My connection string is as follows:
Code:
conn = New SqlConnection("server=localhost;uid=mark;pwd=pword;database=DB1")
Can anybody help me figure this out?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|