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!!!

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!!!

could not find stored procdure xp_availablemedia

hi.
I am getting this error when I try to restore database from device
and try to choose 'filename'.
It's apparently I am missing xp_availablemedia stored procedure, but
where can I get a copy of this and put it in?
Please don't say I need to install full sqlserver again.Try this first:
SELECT * from master..sysobjects where LOWER(name) = 'xp_availablemedia'
How many rows did it return?
If zero, try
sp_addextendedproc N'xp_availablemedia',N'xpstar.dll'
Make sure you are logged on as sysadmin and are in the master database
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<jkim65@.socal.rr.com> wrote in message news:1111731156.502015.190160@.l41g2000cwc.googlegroups.com...
> hi.
> I am getting this error when I try to restore database from device
> and try to choose 'filename'.
> It's apparently I am missing xp_availablemedia stored procedure, but
> where can I get a copy of this and put it in?
> Please don't say I need to install full sqlserver again.
>|||it says
could not find stored procedure 'master.dbo.xp_fixeddrives'.
I guess maybe a bunch of stored procedure in master was deleted for
some reason.
I think I am going to somehow copy these stored procedures from some
other machine.
thanks for the reply.|||> could not find stored procedure 'master.dbo.xp_fixeddrives'.
Are you saying that below query, executed from Query Analyzer returned that error?
SELECT * from master..sysobjects where LOWER(name) = 'xp_availablemedia'
If so, you have some serious issues with your installation.
> I think I am going to somehow copy these stored procedures from some
> other machine.
These are not regular stored procedures. The code for extended stored are in DLL files, and the code
I posted earlier adds the code in the DLL file to SQL Server so it is accessible through TSQL. Did
you try it? Here it is again:
sp_addextendedproc N'xp_availablemedia',N'xpstar.dll'
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<jkim65@.socal.rr.com> wrote in message news:1111945063.141236.209750@.f14g2000cwb.googlegroups.com...
> it says
> could not find stored procedure 'master.dbo.xp_fixeddrives'.
> I guess maybe a bunch of stored procedure in master was deleted for
> some reason.
> I think I am going to somehow copy these stored procedures from some
> other machine.
> thanks for the reply.
>

Could anyone help? backup error

Database: SQL2000
OS: Windows 2000 SP4
Backup device: local hard disk (E Drive)

When I backup the database I got this error: BackupMedium::ReportIoError: write failure on backup device 'E:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\5WavesDB'. Operating system error 112(There is not enough space on the disk.).

My backup file only needs 4G and my E Drive has 13G free. My log files has been set to "growth automatically". Does anyone help to give some advise on this. Thank you for any help.you'd get this error if your data and log device sizes exceed 13g. try to shrink your log device(-s). if this operation does not result in a smaller log device size check for open trans in your database.|||Have you ran chkdsk on this disk? If you really have 13g free it shouldn't be an issue.
Just as an fyi, if you are not doing transaction log backups you need to set your recovery mode to Simple on your databases. Otherwise, your transaction logs will get huge.