question

sand143eep avatar image
sand143eep asked

Can not connect to the server

Hello, i installed sql server 2008 R2 enterprise edition in Clustering mode.it was success. i needed to install reporting services as they are cluster unaware i installed new database engine along with reporting services.when i connect to the new named instance which has reporting services it was throwing error as follows: A network related or instance specific error occured while establishing a connection to sql server. the server was not found or was not accessible.verify that the instance name is correctand that sql server is configured to allow remote connections.(provider:named pipes provider,error: 40 - could not open connection to sql server) (Microsoft sql server, error:53) can any one suggest how to resolve this i checked in configuration manager 1433 port for tcp is used by default instance but the new named instance does not have any tcp port listed what to do.
sql-server-2008sql-server-2012dba
10 |1200

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

1 Answer

·
sand143eep avatar image
sand143eep answered
Hello actually there was server name typo mistake i was providing the server name which i had installed whin i added the computer infront like Computername\instancename of it it started.
1 comment
10 |1200

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

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Nice to know you fixed the problem. Go ahead and mark this as the answer by clicking on the check mark.
0 Likes 0 ·

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.