| Groups | Blog | Home |
sql server msde : Errors while upsizing Access database to SQLS2k
"Create new database" option. I select "LOCAL" as the database. and check [x] use trusted connection. SQL server is on this local machine. I supply a name for the new database and click [Next>] and I get the following error. ================================================================= Connection failed: SQLState: '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]SQL Server does not exist or access denied. ================================================================= Why am I getting these errors? SQL Server is installed to accept mixed mode (or Windows authentication mode) SQL Server is running. VS.Net Professional is loaded on this system so an ODBC driver should be available. What steps, other than I am taking should I be doing?
Are you doing this on the machine that MSDE is running on? If you are trying
to do this remotely then you will not be able to connect to the database server, since you supplied DISABLENETWORKPROTOCOLS=1 as a parameter to your installation. Also since you installed a named instance you will need to supply the full name to the instance, which in your case will be <your machine name>\HipMSDE. (local) will not work as the database server name, as it will try to connect to a server with only the same name as the machine and not the named instance. Jim [quoted text, click to view] "dbuchanan" <dbuchanan52@hotmail.com> wrote in message news:1107749903.811964.185300@g14g2000cwa.googlegroups.com... >I am trying to upsize an Access database to SQL Server 2000. I select > "Create new database" option. > I select "LOCAL" as the database. and check [x] use trusted connection. > SQL server is on this local machine. I supply a name for the new > database and click [Next>] and I get the following error. > > ================================================================= > Connection failed: > SQLState: '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]SQL Server does not exist > or access denied. > ================================================================= > > Why am I getting these errors? > SQL Server is installed to accept mixed mode (or Windows authentication > mode) > SQL Server is running. > VS.Net Professional is loaded on this system so an ODBC driver should > be available. > > What steps, other than I am taking should I be doing? >
Jim,
Thank you for your reply. When I changed the name to the name of my computer "SEDNA", it worked! I thought "(local)" was the proper name to use because the upsizing wizard offered it in the list. I thought it "discovered" that name, and after all the name in Enterprize manager is "(local)" not "SEDNA". Now that you let me in on this sectret, I know. Thank you for tell me the other scret, that I can upsize to MSDE using "SEDNA\HipMSDE". There is know whay I could have guessed this! This all frustrates me very much! How am I supposed to know to use "SEDNA" rather than "(local)" when "(local)" is offered to me in the list? and Enterprize manager does not use "SEDNA"? How am I supposed to know the sintax "SEDNA\HipMSDE" when that is NOT offered in the list? How am I supposed to know the secret code "SEDNA\HipMSDE"? Nothing anywhere tells me this sintax!!?! [quoted text, click to view] > it will try to connect to a server with only the same name as the machine > and not the named instance Where the #%$* am I supposed to discover this! I've been reading these instructions for two days!!!?! I have not seen anything even hinting to this. Why does the system mislead me and accept "(local)" under othere contexts such as VB.NET connection strings. It was the VB.NET connection string context that lead me to guess "SEDNA" because that works in a connection string even though the name of the instance is NOT!!!! "SEDNA", its the name of the machine. Where do I learn all these mysteries? Doug [quoted text, click to view] Jim Young wrote:
> Are you doing this on the machine that MSDE is running on? If you are trying > to do this remotely then you will not be able to connect to the database > server, since you supplied DISABLENETWORKPROTOCOLS=1 as a parameter to your > installation. Also since you installed a named instance you will need to > supply the full name to the instance, which in your case will be <your > machine name>\HipMSDE. (local) will not work as the database server name, as > it will try to connect to a server with only the same name as the machine > and not the named instance. > > Jim > > "dbuchanan" <dbuchanan52@hotmail.com> wrote in message > news:1107749903.811964.185300@g14g2000cwa.googlegroups.com... > >I am trying to upsize an Access database to SQL Server 2000. I select > > "Create new database" option. > > I select "LOCAL" as the database. and check [x] use trusted connection. > > SQL server is on this local machine. I supply a name for the new > > database and click [Next>] and I get the following error. > > > > ================================================================= > > Connection failed: > > SQLState: '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]SQL Server does not exist > > or access denied. > > ================================================================= > > > > Why am I getting these errors? > > SQL Server is installed to accept mixed mode (or Windows authentication > > mode) > > SQL Server is running. > > VS.Net Professional is loaded on this system so an ODBC driver should > > be available. > > > > What steps, other than I am taking should I be doing? > >
hi,
[quoted text, click to view] dbuchanan wrote: > This all frustrates me very much! How am I supposed to know to use > "SEDNA" rather than "(local)" when "(local)" is offered to me in the > list? and Enterprize manager does not use "SEDNA"? How am I supposed > to know the sintax "SEDNA\HipMSDE" when that is NOT offered in the > list? How am I supposed to know the secret code "SEDNA\HipMSDE"? > Nothing anywhere tells me this sintax!!?! >...... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_2xmb.asp you can download BOL (BookOnLine) from http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |