Tuesday, March 20, 2012

Can not conenct to MSDE with VB.NET 2003

Hellow
First i appoligize for my english but I'm from Belgium
Second, this is my problem:
I installed a Server on my Server PC (Windows XP Professional)
setup SAPWD="mypwd" INSTANCENAME="MSDESERVER" DISABLENETWORKPROTOCOLS=0
SECURITYMODE="SQL" TARGETDIR="C:\MSDEINSTALL" /L*v C:\MSDELOG.TXT +
Enter
Works perfect, then I attached a database to it
osql -E -S peter-developer\VA3+ ENTER
EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
@.filename2='C:\test\VA2005_LOG.ldf' + ENTER
This works, and in vb.net i can connect to it with
"Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
Security=SSPI;"
But when i try this from i remote PC (Windows XP) I get an error that
says: SQL server does not exist or access is denied
I searched almost everywhere and i can't find the answer.
EXTRA information
With svrnetcn.exe a set Named pipes, TCP/IP and NWLINK IPX/SPX to
enabled
I put the firewall of, and the firewal of the router is off
Please help me
How do you connect the MSDE from the remote computer? Via an application
with the same ConnectionString as you showed? If yes, that means you are
using Windows security to connect to the MSDE. Is the remote computer on the
same domain network or peer-to-peer network? If it is domain network, you
need to have a SQL Server login created in MSDE that maps to the domain user
account used on that remote computer, or the user logged on to that remote
computer is a domain admin.
Since your MSDE's SQL Server security is enabled, you could specify user
name and password in the ConnectionString (i.e. using SQL Server security,
instead of Windows security). More important thing is to do a bit more study
on SQL Server/MSDE security.
"Thorgal" <declerck_peter@.yahoo.com> wrote in message
news:1164211363.096453.64060@.e3g2000cwe.googlegrou ps.com...
> Hellow
> First i appoligize for my english but I'm from Belgium
> Second, this is my problem:
> I installed a Server on my Server PC (Windows XP Professional)
> setup SAPWD="mypwd" INSTANCENAME="MSDESERVER" DISABLENETWORKPROTOCOLS=0
> SECURITYMODE="SQL" TARGETDIR="C:\MSDEINSTALL" /L*v C:\MSDELOG.TXT +
> Enter
> Works perfect, then I attached a database to it
> osql -E -S peter-developer\VA3+ ENTER
> EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
> @.filename2='C:\test\VA2005_LOG.ldf' + ENTER
> This works, and in vb.net i can connect to it with
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;"
> But when i try this from i remote PC (Windows XP) I get an error that
> says: SQL server does not exist or access is denied
> I searched almost everywhere and i can't find the answer.
> EXTRA information
> With svrnetcn.exe a set Named pipes, TCP/IP and NWLINK IPX/SPX to
> enabled
> I put the firewall of, and the firewal of the router is off
> Please help me
>
|||I'm confused.
In the setup, you indicate that the instance name is: "MSDESERVER", yet in
the connection string you are connecting to: "PETER-DEVELOPER\va3".
Do you have a second instance named [va3]?
Shouldn't you use the instancename [MSDESERVER] in the connection string if
you want to connect to that instance?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thorgal" <declerck_peter@.yahoo.com> wrote in message
news:1164211363.096453.64060@.e3g2000cwe.googlegrou ps.com...
> Hellow
> First i appoligize for my english but I'm from Belgium
> Second, this is my problem:
> I installed a Server on my Server PC (Windows XP Professional)
> setup SAPWD="mypwd" INSTANCENAME="MSDESERVER" DISABLENETWORKPROTOCOLS=0
> SECURITYMODE="SQL" TARGETDIR="C:\MSDEINSTALL" /L*v C:\MSDELOG.TXT +
> Enter
> Works perfect, then I attached a database to it
> osql -E -S peter-developer\VA3+ ENTER
> EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
> @.filename2='C:\test\VA2005_LOG.ldf' + ENTER
> This works, and in vb.net i can connect to it with
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;"
> But when i try this from i remote PC (Windows XP) I get an error that
> says: SQL server does not exist or access is denied
> I searched almost everywhere and i can't find the answer.
> EXTRA information
> With svrnetcn.exe a set Named pipes, TCP/IP and NWLINK IPX/SPX to
> enabled
> I put the firewall of, and the firewal of the router is off
> Please help me
>
|||Arnie Rowland schreef:

> I'm confused.
> In the setup, you indicate that the instance name is: "MSDESERVER", yet in
> the connection string you are connecting to: "PETER-DEVELOPER\va3".
> Do you have a second instance named [va3]?
> Shouldn't you use the instancename [MSDESERVER] in the connection string if
> you want to connect to that instance?
> --
Sorry i copy pasted somethings from the installation board but this is
how it is
setup SAPWD="mypwd" INSTANCENAME="VA3" DISABLENETWORKPROTOCOLS=0
SECURITYMODE="SQL" TARGETDIR="C:\VA3" /L*v C:\MSDELOG.TXT +
Enter
Then attaching the database:
osql -E -S peter-developer\VA3+ ENTER
EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
@.filename2='C:\test\VA2005_LOG.ldf' + ENTER
Sorry for that mistake.
The 2 computers are in the same worgroup, and when i typ
\\peter-developer I see the server PC and I can get files from it or
drop files on the PC.
I want to connect to the VA3 server with a VB.NET 2003 application and
i do it with following connection string
"Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
Security=SSPI;"
Doesn't work
"Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
Security=SSPI;User ID=sa; Password=pass"
Doesn't work
"Data Source=PETER-DEVELOPER\va3,1433;Initial Catalog=VA2005;Integrated
Security=SSPI;User ID=sa; Password=pass"
Doesn't work
"Data Source=Peter-developer\VA3,1433;Network
Library=DBMSSOCN;Integrated Security=SSPI;Initial Catalog=VA2005;User
ID=peter;Password=peter"
Doesn't work ether
You say something about making a new user, I don't understand that,
could you explain it again please
|||You do not need to combine both "Integrated Security=SSPI" AND "User ID=sa;
Password=pass".
It is EITHER "Integrated Security=SSPI" OR "User ID=sa; Password=pass".
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Thorgal" <declerck_peter@.yahoo.com> wrote in message
news:1164269346.083379.243730@.l12g2000cwl.googlegr oups.com...
> Arnie Rowland schreef:
>
> Sorry i copy pasted somethings from the installation board but this is
> how it is
> setup SAPWD="mypwd" INSTANCENAME="VA3" DISABLENETWORKPROTOCOLS=0
>
> SECURITYMODE="SQL" TARGETDIR="C:\VA3" /L*v C:\MSDELOG.TXT +
> Enter
> Then attaching the database:
> osql -E -S peter-developer\VA3+ ENTER
> EXEC sp_attach_db @.dbname='VA2005',@.filename1='C:\test\VA2005.mdf',
> @.filename2='C:\test\VA2005_LOG.ldf' + ENTER
>
> Sorry for that mistake.
> The 2 computers are in the same worgroup, and when i typ
> \\peter-developer I see the server PC and I can get files from it or
> drop files on the PC.
> I want to connect to the VA3 server with a VB.NET 2003 application and
> i do it with following connection string
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;"
>
> Doesn't work
> "Data Source=PETER-DEVELOPER\va3;Initial Catalog=VA2005;Integrated
> Security=SSPI;User ID=sa; Password=pass"
> Doesn't work
> "Data Source=PETER-DEVELOPER\va3,1433;Initial Catalog=VA2005;Integrated
> Security=SSPI;User ID=sa; Password=pass"
> Doesn't work
> "Data Source=Peter-developer\VA3,1433;Network
> Library=DBMSSOCN;Integrated Security=SSPI;Initial Catalog=VA2005;User
> ID=peter;Password=peter"
> Doesn't work ether
> You say something about making a new user, I don't understand that,
> could you explain it again please
>
sql

No comments:

Post a Comment