Securely logging onto an SQL server

[Boris Zakharin]

How do I log onto an SQL server without saving my password in the connection
string?

[Sreejumon[MVP]]

Hi,

If you SQLServer and WebServer in same network you can have Trusted Connection. Please try the followings.
"Data Source=Pubs;Initial Catalog=pubs;Integrated Security=SSPI;"
- or -
"Server=Pubs;Database=pubs;Trusted_Connection=True ;"


--
Let me know if you need further help

Regards
Sreejumon[MVP]
[url]www.mstechzone.com[/url]

"Boris Zakharin" <zakharin@alumni.upenn.edu> wrote in message news:uRpQUejVDHA.1912@TK2MSFTNGP11.phx.gbl...

> How do I log onto an SQL server without saving my password in the connection
> string?
>
>

[Boris Zakharin]

The server is not on the same network (well, it is once it's moved to the
production machine, but even then both are on remote hosting machines and I
can only access the SQL server via IP address)

"Sreejumon[MVP]" <sreeju_uss@hotmail.com> wrote in message
news:OG1WOAkVDHA.2016@TK2MSFTNGP09.phx.gbl...

> Hi,
>
> If you SQLServer and WebServer in same network you can have Trusted

Connection. Please try the followings.

> "Data Source=Pubs;Initial Catalog=pubs;Integrated Security=SSPI;"
> - or -
> "Server=Pubs;Database=pubs;Trusted_Connection=True ;"