Counter settings: msde

Showing posts with label msde. Show all posts

Thursday, March 22, 2012

Couldn't connect to MSDE

Hi all,

I'm developing smart device application in VB.NET.

I couldn't make the connection with MSDE.

MSDE is on the same machine where i'm developing my apps. & testing the result with emulator. (NOt using RDA or Replication).Simply using ADO.NET commands to select a table from MSDE engine.

Connection strings that i've tried:

In a stand alone System:

1)strconnection = "Server = 10.0.0.7;" & "Data Source =HOME\MYINS,1029;" & "Database = TEST;" & "Integrated Security=sspi;"

2)strconnection = "Server = 10.0.0.7;" & "Data Source =HOME\MYINS,1029;" & "Database = TEST;" & "Integrated Security=sspi;" & "User ID =vino;"& "Password =pavi;"

3)strconnection = "Server = 10.0.0.7;" & "Data Source =HOME\MYINS;" & "Database = TEST;" & "Integrated Security=sspi;" & "User ID =vino;"& "Password =pavi;"

In a Domain :
Server Machine name: FCC
Instance Name : FCC\MYINS

1)connectionString = "Integrated Security=sspi;User ID=DSTA\vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\MYINS";

2)connectionString = "Integrated Security=false;User ID=vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\MYINS";

3)connectionString = "Integrated Security=sspi;User ID=DSTA\vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\MYINS,1043";

4)connectionString = "Integrated Security=false;User ID=vino;Password=pavi;Initial Catalog=TEST;Data Source=FCC\FCC\MYINS,1043";

Errors when using standalone system:

1st connection given me error -> Login failed for user "HOME\Guest. (NOte:ALready i enabled the guest account)
2nd connection ->server not found or access denied.

In a Domain:

server not found or access denied Error.

My Computer Settings:

Computer name :HOME
WorkGroup:MSHOME
Guest account Enabled.
I've two instances in My Enterprise Manager
1) (local)(WIndows NT) - SQL server 2000
2) HOME\MYINS -MSDE instance.

I don't know what to do ? Any other setting are there? I tried in three standalone machines loaded with MSDE. but the same result.

Is there any other setting in Emulator? If so how come SQL server 2000 instance working well?

Please advice me to solve this problem. Nearly 4 days i spent to find the solution.But I couldn't. Kindly suggest me ideas.

Thank You.

Note:
1) Windows apps working well with this connection string.

2) In MSDE , TCP/IP & named Pipes are enabled.
Port NO : 1029 (I've seen it by selecting Properties then N/W Configuration)

3)Connectionis suceessfully established when i used SQL server 2000 instance.
But failed for MSDE.

4)In addition i've configured loopback adapter with valid IP(10.0.0.7).But No improvement with my connection.

1) Is your MSDE instance configured as Windows Authentication or Mixed Auth? Make sure you configure it as Mixed Auth if you want to use user ID/Password.

2) By "Guest account Enabled.", do you mean guest account in SQL Server or Windows? or both?

<<<< 1st connection given me error -> Login failed for user "HOME\Guest. (NOte:ALready i enabled the guest account) >>>>
This error msg means you are able to connect to the server, but failed because of credential. You have not grant access to HOME\Guest in MSDE. (windows authen is used here)

3) Have you checked errorlog or eventlog to get more info?

|||

Hi,

1) I'm using Mixed mode authentication.

2) Actually Guest account in Windows server 2003 was disabled earlier. I Enabled it manually.

3)I didn't chect Eventlog &errorlog. how to check them?

is it like Mycomputer--> Manage >services?

4)I've dirctly connected my PDA with server .it's not pinging.

PDA IP : xxx.xxx.x.101(i've selected VPN connection )

server IP :xxx.xxx.x.100.

In case of emulator, apps running m/c(windows xp) is pinging with server.

But connection not established.

How to make PDA to ping with server? & how to establish a successful connection?

Thanks!!!

Tuesday, March 20, 2012