question

ADIL avatar image
ADIL asked

SQL Server 2005 Connection Help

i run the SQL Server 2005 setup on one machine(A) .it works good on that machine.But when i run the same setup on second machine(B) it will install the sql server on that machine with the server name (xyz).when i try to connect to the sql server on machine (B) through wonderware(intouch 10.1) in alarm DB logger manager it display the error message "Connection to the server is not available".But if i connect the sql server through wonderware(intouch 10.1) in alarm DB logger manager on machine (A) from machine (B) it will connect.Both the machines are on network.But i want both the machines use seperate SQL server.

sql-server-2005
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Wes Brown avatar image
Wes Brown answered

SQL Server configration manager has the settings for protocols and services.

Check the protocols on both machines and see if they have tcp/ip and named pipes enabled. Check the SQL Server Browser is it enabled and running on the working machine but not the new install? Are both installs the same, i.e. 32 bit standard edition sql server 2005 or is the new install 64 bit developer etc.

I don't know how wonderware works under the covers that would be a starting point for me.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RickD avatar image
RickD answered

Can you connect to Machine B from Machine A using SQL Server Management Studio? Have you set the Surface Area of Machine B to allow remote connections?

Please provide more information if you expect your question to be answered.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

user-101 (yahoo) avatar image
user-101 (yahoo) answered

yes i am able to connect to machine (A) using SQL server management studio from machine (B).And also able from wonderware to connect to machine (A) SQL server.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.