all groups > sql server clients > october 2007 >
You're in the

sql server clients

group:

Remoting Access to SQLServer 2005


Remoting Access to SQLServer 2005 JP
10/16/2007 4:38:00 AM
sql server clients:
Hi,

I installed SQLServer with a instance using the following cmd:

/qn INSTANCENAME=MYINSTANCE ADDLOCAL=All SQLCOLLATION=Latin1_General_CI_AI
=Latin1_General_CI_AI PIDKEY=ABCDE12345FGHIJ67890KLMNO SECURITYMODE=SQL
SAPWD=Pass SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0

When I try to connect to the server using VS2005 (VB) using the code:

Dim instance As System.Data.Sql.SqlDataSourceEnumerator =
System.Data.Sql.SqlDataSourceEnumerator.Instance
Dim table As System.Data.DataTable = instance.GetDataSources()

For Each DRrow As DataRow In table.Rows 'DRrows
C1List1.AddItem(DRrow(0).ToString & ";" & DRrow(1).ToString &
";" & DRrow(3).ToString)
Next

I can see the Server Name, but not the Instance.
I've already checked the SQL Configurantion Manager, and I've allowed this
instance to accept remote connections (created by the cmd install command).

NOTE: I'm testing the connection on a Domain, but only using the SA account
(SQLmode).

Can somebody help me?
Thanks.

PS: I also created an Firewall exception in Windows on the port 1433.

AddThis Social Bookmark Button