SQL sever

20 pts.
Tags:
SQL Server 2005
Hi, Thanks Flame. I followed the steps in the link you gave. I got to where it prompted for id and password and click next after that but it gives error message as below. Connection failed SQLState: '01000' SQL ServerError: 14 [Microsoft][ODSC SQL Server Driver][DBNETLIB]ConnectionOpen (ParceConnectParams()). Connection Failed SQLState; '08001' SQL Sever Error: 14 [Microsoft][ODSC SQL Server Driver][DBNETLIB]invalid connection. At the point it promted for Name; Description; and Server, I had used Wallchart Live Data as name Optional as Description and 74.93.47.20:1433 as IP. Please what could be the problem and what should I do. Thanks Chuks

Answer Wiki

Thanks. We'll let you know when a new response is added.

Creating a data source name (DSN) has nothing to do with using the SQL Server Express Management Studio.

Open the management studio.
It should open a Connect To Server window. If not, click on the File drop down menu, and select “Connect Object Explorer”. In this Connect To Server window enter in the servername (or IP Address), username and password which were supplied.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following