19 июля 2012 г. 8:44
19 июля 2012 г. 8:57
SQL Server Browser does not have the type field populated in SQL Config Manager. Can you connect successfully from the local server version of SSMS? It sounds like the browser service is running. What error do you receive? Did you enable remote connections for the server instance? Have you configured the firewall to allow the SQL server ports?
19 июля 2012 г. 9:02
Is your SQL Browser service running, if not try to RUN it....
share the error if it fails on startup...
19 июля 2012 г. 9:18
To assure databases Access , you have to follow up the following :
1- Assure static Port is assigned for SQL Service from Computer Management >>>Services & applications >>> SQL Server Configuration Manager >>SQL Server Network Configurations >>Protocol for Instance name>>TCP>>IP address >IPAl l>>TCP port >>>>>then assign any appropriate port like TCP 1433 (Default )
2- Assure the below same TCP ports assigned per 1<sup>st</sup> step +UCP 1434 (SQL browser port) are open from your source to destination
3- If still persist, you have to work out the usage of alias through SQL Server Client network utility by opening Run >>Cliconfg.exe >>Alias >>>Add >>>TCP /IP >>>then specify the appropriate alias (MAY be the same as the original connection string) >>>>and mark out dynamic port to let static by the same port above
4- If still persist, you might use the same connection string but with adding the suffix (,TCP port) like Servername\Instancename ,1433
Please let me work out it and let me know your feedback
Shehap (DB Consultant/DB Architect) Think More deeply of DB Stress Stabilities
19 июля 2012 г. 13:55
Please read the following link to know that are you facing problem because of SQL Server Browser? And let me know your problem resolved or not?