connection to sql server - 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

connection to sql server

Author

Topic

Diya
Starting Member

11 Posts

Posted - 2009-03-16 : 14:21:48

I created an access database using Access 2003. It is splitted into back-end containg related tables and front-end database containg queries forms etc. Now I am trying to upsize only the back-end database to sql server database through upsizing wizard of Ms Access in order to overcome the 2GB limitation of Access database. I want to retrieve data through jet database engine. But I couldnt upsize. I got following message after going through the upsizing wizard:
"Connection failed:
SQL State 01000
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection failed
SQLState: 08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQLServer does not
Exist or access denied"
I installed SQL Server 2005 express edition (version 9.3.403500).
My work is limited within the local machine. I dont want to use networking.
What should I do?
Anyone can help me anyway?
With best regards,
Diya

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-16 : 14:45:53

Diya first think I would recommend using SSMA, link: http://www.microsoft.com/downloads/details.aspx?FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&displaylang=en

This tool is far better then then MS Upsizing wizard. As for you SQL Server, can please confirm that it is set to start automatically on your computer?

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Diya
Starting Member

11 Posts

Posted - 2009-03-20 : 12:08:13

Thanks for your kind suggestion.
Yes it is set to start automatically on my computer.
But after using the SSMA also I couldnt connect. I got following error message "A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connection". Please help me.
with best regards,
diya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-20 : 12:13:44

go to configuration manager under sql server -> configuration tools and check if MSSQL serviceis runing and also allow remote connections is set

gvphubli
Yak Posting Veteran

54 Posts

Posted - 2009-03-20 : 20:26:07

Try other connection methods like osql. Goto command line and try,

osql -S<server> -E (if using window auth.)

else

osql -S<server> -U <UserName> -P <Pwd> (if using Mixed Auth)

Apart from this, few other trivial stuff to check - server name, is it running or not.

TechnologyYogi
http://gvphubli.blogspot.com/

Diya
Starting Member

11 Posts

Posted - 2009-03-20 : 22:00:50

quote:
Originally posted by visakh16

go to configuration manager under sql server -> configuration tools and check if MSSQL serviceis runing and also allow remote connections is set

Thanks. Yes I checked configuration tools and the MSSQL services is running and also the remote connection is also set. I couldnt get any way whats the matter. 'The express edition of SQL Server is only for local connection'- is it true? Whether the installation is not done in proper way? What should I do? Can you help me in any way?

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2009-03-21 : 03:11:47

What are you referencing the the SQL Server Express as?
Have you got all the right protocols enabled? i.e the TCP\IP protocol found in the Surface Area Configuration

Jack Vamvas
--------------------
http://www.ITjobfeed.com

Diya
Starting Member

11 Posts

Posted - 2009-03-21 : 07:26:08

Yes, TCP\IP protocol is found in the surface area configuration.
Thanks for your response.
With best regards,
Diya

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-21 : 17:32:43

quote:
Originally posted by Diya
I checked configuration tools and the MSSQL services is running and also the remote connection is also set. I couldnt get any way whats the matter. 'The express edition of SQL Server is only for local connection'- is it true? Whether the installation is not done in proper way? What should I do? Can you help me in any way?

By default setting yes; you can look at the surface area configuration to see if remote connections are allowed as Visakh16 suggested. This is also true if you are using developer edition.

Its been a long while since i used express edition so I don't remember if express comes with surface area configuration utility. But you can run following command in SSMS to check ...

sp_configure 'remote access'

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources