REMOTE CONNECTIVITY TO SQL EXPRESS

Question

REMOTE CONNECTIVITY TO SQL EXPRESS

narayanakutty

Grasshopper

Points: 16
More actions
May 12, 2008 at 9:37 am

#186466

hI
I am trying to connect SQL Express from a remote computer thru the following connection string .
Dim ConnString As String = "Provider=SQLOLEDB;Data source= ,1433\SQLEXPRESS;" & _
"Initial Catalog= ;"
But i am getting the following error message .
"Invalid authorisation specification"
"Invalid connection string attribute"
Can any help me on this issue ?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Animal Magic SSChampion Points: 13964 More actions · Answer 1

If its a new installation its probably because by default sql express (and dev) doesnt allow remote connections. to change this go to the surface area configuration tool and go to features (i think), change it to allow local and remote connections.

John

Lowell SSC Guru Points: 323518 More actions · Answer 2

additionally, if you are running any operating system with windows firewall, you will need to add an exception for sql server...you have to browse to sqlserver.exe for each service you are going to run, for example C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlserver.exe might be the executable running the named instance of{yourmachinename}\SQLEXPRESS

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

narayanakutty Grasshopper Points: 16 More actions · Answer 3

HI

I have already enabled the remote connections for the SQL Express.

Currently my system's firewall setting is OFF mode.

But I am connected to local intranet of my company.

Please suggest me any help.

thanks

Shan

alimcitp SSC Eights! Points: 930 More actions · Answer 4

Integrated Security = true;

Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate

Lowell SSC Guru Points: 323518 More actions · Answer 5

i think alimcitp has nailed it; your connectionstring doesn't have a username/password or integrated security:

you need to know your machine name; the constring you had was clearly incorrect.

it's machinename\instnacename,port

so if my machine is named "developer", and the name dinstance was SQLEXPRESS, and you know it was on port 1207, you'd use

Data Source=developer\SQLEXPRESS,1207

here's an example of what i use for a non-integerated securituy string.

connectionstrings.com could help you out as well.

Connstring="Provider=SQLOLEDB;Data Source=d241\SQLEXPRESS;User ID=sa;Password=mysecretpassword;Persist Security Info=True;Initial Catalog=master;Network Library=dbnetlib"

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!