Connection string issue for sql authentication

Question

Connection string issue for sql authentication

ushacheb

Grasshopper

Points: 18
More actions
November 7, 2013 at 2:38 pm

#300030

Can anyone pls help me with this issue
I have the below connection string in my config file but when I open the connection manager I see a blank password for sql authentication though I pass it in my connnection string ..I have seen lot of posts suggesting to change the protection level and the persist security info but it didnt help me ..
Provider=sqloledb;Data Source=22.33.11.197,1000;Network Library=DBMSSOCN;User ID=Domain\FirstName.LastName;Password=xxxxxxxx;Initial Catalog=ftyuas1;Persist Security Info=True;Auto Translate=False;

Viewing 4 posts - 1 through 3 (of 3 total)

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

Eddie Wuerch SSChampion Points: 12535 More actions · Answer 1

Are you attempting to connect using your Windows domain credentials (user Domain\UserName)? If so, you don't specify user name or password. You just have to set it to use Windows Authentication:

Instead of:

Provider=sqloledb;Data Source=22.33.11.197,1000;Network Library=DBMSSOCN;~~User ID=Domain\FirstName.LastName;Password=xxxxxxxx~~;Initial Catalog=ftyuas1;Persist Security Info=True;Auto Translate=False;

Use this:

Provider=sqloledb;Data Source=22.33.11.197,1000;Network Library=DBMSSOCN;Integrated Security=SSPI;Initial Catalog=ftyuas1;Persist Security Info=True;Auto Translate=False;

Eddie Wuerch
MCM: SQL

ushacheb Grasshopper Points: 18 More actions · Answer 2

Thank You for your reply Eddie . Am not using windows credentials ...access to this server is given with a different domain . Thank You

Lowell SSC Guru Points: 323518 More actions · Answer 3

ushacheb (11/8/2013)
Thank You for your reply Eddie . Am not using windows credentials ...access to this server is given with a different domain . Thank You

Pretty sure SQL server will not accept/allow a SQL loginwith a slash; that's only allowed for windows based login...in which case you have to use integrated security like Eddie suggested.

so if you are trying to grant access to a domain user form another domain, i think you have to establish a trust between the two domains, or actually create a SQL user to be used in that situation.

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!