المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Connecting to SQL 2005 named instance



C# Programming
05-13-2009, 06:50 PM
I can connect to the default instance of SQL using SQL MGMT Studio by providing the FQDN. The problem is I can not connect to the named instance. The problem is I can not find the syntax for providing FQDN for a named instance.

I am only using Mgmt studio to test because I am writing an app but the connection fails. I tried using IP Address and port number, fqdn and port number but no luck. I also tried by giving the instance name an alias and still no luck. I am using sql authentication.

I can access everything fine if I am on the network but outside the network is where the issues arise.

Any help would be appreciated! Googling did not help, neither did MSDN.

CodingYoshi

Visual Basic is for basic people, C# is for sharp people. Farid Tarin '07