Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server access denied

Status
Not open for further replies.

ksbrace

Programmer
May 13, 2000
501
US
Hello,
I have 2 people working on a project that accesses SQL Server DB. One of the people have the DB on their pc. The other cannot get to the DB. They keep getting "SQL Server doesn't exist or access denied" on the connection.open() line.
Here's what my connection string looks like:
Code:
<add key="ConnectionString" value="server=10.0.0.2;database=IBS;uid=username;pwd=password" />
Both users are on the "10" network. The uid and pwd work just fine on the pc that holds the DB. Any help or ideas would be greatly appreciated. Thanks in advance!


 
Does the computer where the SQL DB is installed has an Firewall? Maybe the 1433 port (default SQL TCP port) is blocked for incoming connections.

[morning]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top