URGENT- Unable to connect to the SQL Server

[Zalak Dedhia via DotNetMonster.com]

Hello Guys,

I need some help urgently regarding the code to connect to the SQl Server
on a remote machine and possible configurations to make, or chanegs in the
connection string or so.

I mean i keep getting the error "SQL Server or Access denied"

To rectify this i have used 'n' number of diff combinations of the
conenction string with the SQLConnection methos, please let me know if they
are correct or if there is something that needs to be added

The various connection strings tried:-

myConnectionStr ing = "Initial Catalog=Northwi nd;Data Source=\\
blrkec25251;Int egrated Security=SSPI;"

myConnectionStr ing = "Persist Security Info=False;Inte grated
Security=SSPI;d atabase=northwi nd;server=MSSQL SERVER;data
source=blrkec25 251;user ID=zalak;pwd=de dhia"

myConnectionStr ing = "User ID=zalak;pwd=de dhia;Initial
Catalog=Northwi nd;Data Source=MSSQLSER VER;Workstation ID=blrkec25251"

myConnectionStr ing = "data source=blrkec25 251;initial
catalog=Northwi nd;uid=sa;pwd=S ysAdmin"
myConnectionStr ing =
"uid=sa;pwd=Sys Admin;database= Northwind;serve r=192.168.206.9 7"

I need to know what exactly to out the value for each of these parameters
needs to be

SERVER
INITIAL CATALOG
Data Source
Workstation Id
thanks and regards,
zalak

[Locke]

Check out this website

http://www.connectionstrings.com/

Locke

"Zalak Dedhia via DotNetMonster.c om" <fo***@nospam.D otNetMonster.co m> wrote
in message news:7b******** *************** *******@DotNetM onster.com...

Hello Guys,

I need some help urgently regarding the code to connect to the SQl Server
on a remote machine and possible configurations to make, or chanegs in the
connection string or so.

I mean i keep getting the error "SQL Server or Access denied"

To rectify this i have used 'n' number of diff combinations of the
conenction string with the SQLConnection methos, please let me know if
they
are correct or if there is something that needs to be added

The various connection strings tried:-

myConnectionStr ing = "Initial Catalog=Northwi nd;Data Source=\\
blrkec25251;Int egrated Security=SSPI;"

myConnectionStr ing = "Persist Security Info=False;Inte grated
Security=SSPI;d atabase=northwi nd;server=MSSQL SERVER;data
source=blrkec25 251;user ID=zalak;pwd=de dhia"

myConnectionStr ing = "User ID=zalak;pwd=de dhia;Initial
Catalog=Northwi nd;Data Source=MSSQLSER VER;Workstation ID=blrkec25251"

myConnectionStr ing = "data source=blrkec25 251;initial
catalog=Northwi nd;uid=sa;pwd=S ysAdmin"
myConnectionStr ing =
"uid=sa;pwd=Sys Admin;database= Northwind;serve r=192.168.206.9 7"

I need to know what exactly to out the value for each of these parameters
needs to be

SERVER
INITIAL CATALOG
Data Source
Workstation Id
thanks and regards,
zalak

[Ken Tucker [MVP]]

Hi,

You probably will have to check with system administrator to get the
server name if it is wrong but one of these 2 should work. Integrated
Security = sspi means it uses your windows login to verify you have access to
sql server. Data source and server are the name of the sql server. Data
source = server only need to specify one not both. Initial catalog is the
database name. Can use database or initial catalog. Workstation id is the
name of the computer connecting to the sql server.

myConnectionStr ing = "database=north wind;data source=blrkec25 251;user
ID=zalak;pwd=de dhia"

or

myConnectionStr ing = "Integrated Security=SSPI;d atabase=northwi nd; data
source=blrkec25 251;"

http://msdn.microsoft.com/library/de...tringtopic.asp

Ken
--------------------
"Zalak Dedhia via DotNetMonster.c om" wrote:

Hello Guys,

I need some help urgently regarding the code to connect to the SQl Server
on a remote machine and possible configurations to make, or chanegs in the
connection string or so.

I mean i keep getting the error "SQL Server or Access denied"

To rectify this i have used 'n' number of diff combinations of the
conenction string with the SQLConnection methos, please let me know if they
are correct or if there is something that needs to be added

The various connection strings tried:-

myConnectionStr ing = "Initial Catalog=Northwi nd;Data Source=\\
blrkec25251;Int egrated Security=SSPI;"

myConnectionStr ing = "Persist Security Info=False;Inte grated
Security=SSPI;d atabase=northwi nd;server=MSSQL SERVER;data
source=blrkec25 251;user ID=zalak;pwd=de dhia"

myConnectionStr ing = "User ID=zalak;pwd=de dhia;Initial
Catalog=Northwi nd;Data Source=MSSQLSER VER;Workstation ID=blrkec25251"

myConnectionStr ing = "data source=blrkec25 251;initial
catalog=Northwi nd;uid=sa;pwd=S ysAdmin"
myConnectionStr ing =
"uid=sa;pwd=Sys Admin;database= Northwind;serve r=192.168.206.9 7"

I need to know what exactly to out the value for each of these parameters
needs to be

SERVER
INITIAL CATALOG
Data Source
Workstation Id
thanks and regards,
zalak

[Zalak Dedhia via DotNetMonster.com]

Thanks Ken Tucker.

I got a good insight into the various parameters but have not yet tried to
deal with the problem. Shall let you know if i could solve it!!

Thanks again,
Zalak

--
Message posted via DotNetMonster.c om
http://www.dotnetmonster.com/Uwe/For...b-net/200505/1

[Zalak Dedhia via DotNetMonster.com]

Thanks Locke

Will try to use this and let you know if any other queries arise.

Thanks again,
Zalak

--
Message posted via DotNetMonster.c om
http://www.dotnetmonster.com/Uwe/For...b-net/200505/1