Newbie needs urgent help! - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Newbie needs urgent help!

Author

Topic

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 12:18:31

hi all

using Win XP Pro

I'm new to MSDE/SQL Server but fairly experienced with other systems.
I've been asked to upsize an existing Access db to SQL Server so ...
step #1 I downloaded MSDE no probs
step #2 I try to connect - Arrrgh! I cannot connect!
help!

X002548
Not Just a Number

15586 Posts

Posted - 2006-12-20 : 12:39:17

Well you should probably be using SQL Server 2005 Express edition, which is also a free download

Also, you will probably need to reformulate your question and supply some more details

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-20 : 12:56:36

Stop the firewall!
Use proper username/password combination!
Select the appropriate sql server machine!

Peter Larsson
Helsingborg, Sweden

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 13:14:43

Hi
here's a few more details:

I've checked that the service is running (the Instance name is test)

Using SQL Server Service Manager:
I choose SQL Server in Server combo
but
there is nothing in the Services combo

If I click refresh I receive the following message:
The network path is not found

What is the difference between MSDE and SQL Server 2005 Express?

I switched off my firewall

many thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-20 : 13:22:18

Which version of SQL Server did you try to install on your Windows XP?

Peter Larsson
Helsingborg, Sweden

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 13:29:12

I installed MSDE

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-20 : 13:36:46

How are you trying to connect to MSDE? Using osql.exe? What server are you trying to connect to? It should be YourHostName\Test. To see what YourHostName should be, go to a cmd window (Start..Run, tyype cmd and hit enter), type hostname and hit enter.

Tara Kizer

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 13:42:12

in a DOS window I enter:

osql hostname\test

I receive a list of OSQL's switches

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-20 : 13:44:36

You aren't using osql.exe correctly.

Here's an example that uses Windows Authentication:
osql -Shostname\test -E

Here's an example that uses SQL authentication:
osql -Shostname\test -Usomeuser -Psomepassword

Run osql /? to see the switches. You can read about each of them in SQL Server Books Online.

Next time it would be faster if you told us the exact error or messages and how you were trying to connect.

Tara Kizer

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-20 : 13:46:56

I didn't know that SQL Server Service Manager came with MSDE.

Peter Larsson
Helsingborg, Sweden

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 13:51:40

OK getting somewhere ....

using:

osql -Shostname\test -E

I receive:

1>

not sure where to go from here ..

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-20 : 13:53:29

That's where you type your commands. Like this:

1> SELECT * FROM sysobjects
2> GO

It's all command line, so it's going to be tough if you are a newbie. You probably will want to consider SQL Server 2005 Express. There are loads of differences between the two, but they are both free. Express gives you GUI tools though, which would help out a newbie. Plus Express is the newest version.

Tara Kizer

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 14:01:19

First of all - Hail SQL Goddess!

Secondly I have had some exposure to MySQL (Is that a dirty word in this forum?)

I take it that there is no line terminator (like ;) and that you require GO to process the SQL statements

Q1. Why was no p/w required to connect?
Q2. How do I see what databases are there?
Q3. Why is SQL Server Service Manager not playing ball?

... so many questions ...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-20 : 14:06:25

osql requires the GO statements. You wouldn't put these in your application though.

Q1. Because you used Windows Authentication to connect.
Q2. SELECT * FROM sysdatabases
Q3. I don't know. I use the Services applet in Control Panel..Admin Tools rather than the service manager.

Tara Kizer

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 14:24:38

OK so I am connected through osql concole but ...

are you familiar with MS Access?

When trying the Upsizing Wizard MS Access fails to connect .. I receive:

Connection failed
SQLState '01000'
SQL Server Error: 2
[Microsoft[ODBC SQL Server Driver][Shared Memory(ConnectionOpen (Connect(0).
Connection failed:
SQLState:'08001'
SQL Server Error: 17
[Microsoft[ODBC SQL Server Driver][Shared Memory]SQL Server Does Not Exist or Access Denied

I've tried Trusted Connection and supplying a User and pw but so far no joy

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-20 : 14:29:58

Is Access on the same machine as the MSDE installation?

And no I'm not familiar with Access, but I am familiar with the error. It's a SQL Server error rather than an Access error.

Tara Kizer

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 14:30:43

yes it is

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-20 : 14:41:48

I doubt you have Server Network Utility installed since you've got MSDE, so we'll need to do things via the registry.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\TEST\MSSQLServer\SuperSocketNetLib

What does the ProtocolList string value say for its data?

Tara Kizer

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 14:42:09

Perhaps more fundamentally I cannot create a ODBC DSN to SQL Server

deBassMan
Starting Member

15 Posts

Posted - 2006-12-20 : 14:44:32

Its Value Data is empty

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-20 : 14:48:27

Let's try adding tcp to the value data, then restart the MSSQL$Test service.

Once that is done, we need to add a string value to this location:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

The string value would be YourHostname\Test. Its data would be DBMSSOCN,YourHostname\Test,PortNumber. To get the value of PortNumber, we need to check this location:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\GTW1\MSSQLServer\SuperSocketNetLib\Tcp

It's in the TcpPort string value.

Once done, you should be able to create a DSN using YourHostname\Test and the test should work.

Tara Kizer

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources