SP1 Issue returns error!

[Jay]

Everytime I run SP1 I get this error

[DBNETLIB]Specified SQL server not found.
[DBNETLIB]ConnectionOpen (Connect()).

Error encountered while running UPGPJ111.SQL!

I am running SQL server locally and it is not a named instance. I am logged
into server as an admin with a domain account. The command line I am running
is
upgdb111.cmd [servername] [projectserver] [login] [password]

Am I doing something wrong here?

 

[Gary L. Chefetz \(MVP\)]

Jay:

upgdb111.cmd [servername] [projectserver] [login] [password]

Should be:

upgdb111.cmd [servername/instancename] [projectserver] [login] [password]


--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

 

[Jay]

Tried that and still no go. Remeber I am not running a named instance. The
name is "local" so should it be [servername/servername] or
[servername/local] or what? Becasuse I also tried both of these and still no
go! I am stuck like chuck!!!

Jay:

upgdb111.cmd [servername] [projectserver] [login] [password]

Should be:

upgdb111.cmd [servername/instancename] [projectserver] [login] [password]


--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

Everytime I run SP1 I get this error

[DBNETLIB]Specified SQL server not found.
[DBNETLIB]ConnectionOpen (Connect()).

Error encountered while running UPGPJ111.SQL!

I am running SQL server locally and it is not a named instance. I am logged
into server as an admin with a domain account. The command line I am running
is
upgdb111.cmd [servername] [projectserver] [login] [password]

Am I doing something wrong here?

 

[Gary L. Chefetz \(MVP\)]

Read your first post wrong, sorry, I thought you said it was a named
instance. What directory are you in when you're running the command? It
appears as though either the command is not seeing the OSQL interpreter or
the username and password is incorrect. Are you using the build-in SA
account. It has magic powers, you know.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

Tried that and still no go. Remeber I am not running a named instance. The
name is "local" so should it be [servername/servername] or
[servername/local] or what? Becasuse I also tried both of these and still no
go! I am stuck like chuck!!!

Jay:

upgdb111.cmd [servername] [projectserver] [login] [password]

Should be:

upgdb111.cmd [servername/instancename] [projectserver] [login] [password]


--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

Everytime I run SP1 I get this error

[DBNETLIB]Specified SQL server not found.
[DBNETLIB]ConnectionOpen (Connect()).

Error encountered while running UPGPJ111.SQL!

I am running SQL server locally and it is not a named instance. I am logged
into server as an admin with a domain account. The command line I am running
is
upgdb111.cmd [servername] [projectserver] [login] [password]

Am I doing something wrong here?

 

[Jay]

I am running the update from this directory C:\Program Files\Microsoft SQL
Server\80\Tools\Binn with the SA login. Where osql.exe resides!
I don't see its magic powers yet.

Read your first post wrong, sorry, I thought you said it was a named
instance. What directory are you in when you're running the command? It
appears as though either the command is not seeing the OSQL interpreter or
the username and password is incorrect. Are you using the build-in SA
account. It has magic powers, you know.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

Tried that and still no go. Remeber I am not running a named instance. The
name is "local" so should it be [servername/servername] or
[servername/local] or what? Becasuse I also tried both of these and still no
go! I am stuck like chuck!!!

Jay:

upgdb111.cmd [servername] [projectserver] [login] [password]

Should be:

upgdb111.cmd [servername/instancename] [projectserver] [login] [password]


--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-
Everytime I run SP1 I get this error

[DBNETLIB]Specified SQL server not found.
[DBNETLIB]ConnectionOpen (Connect()).

Error encountered while running UPGPJ111.SQL!

I am running SQL server locally and it is not a named instance. I am
logged
into server as an admin with a domain account. The command line I am
running
is
upgdb111.cmd [servername] [projectserver] [login] [password]

Am I doing something wrong here?

 

[Earl Lewis]

Jay,

What are you using for the servername parameter? Are you using your machine name or localhost or local or what?

Is the SQL service running and able to be connected to via other means? I'm assuming so, but you never know.

Can you create an ODBC connection to it and successfully connect?

Sorry no firm answers. You gotta start somewhere. Good luck!

Earl
Everytime I run SP1 I get this error

[DBNETLIB]Specified SQL server not found.
[DBNETLIB]ConnectionOpen (Connect()).

Error encountered while running UPGPJ111.SQL!

I am running SQL server locally and it is not a named instance. I am logged
into server as an admin with a domain account. The command line I am running
is
upgdb111.cmd [servername] [projectserver] [login] [password]

Am I doing something wrong here?

 

[Rob Stewart]

Jay, to echo Earl, with regards to not intending to be condescending,
Are you including the brackets [] in your cmd session to initiate the SQL SP?

I am running the update from this directory C:\Program Files\Microsoft SQL
Server\80\Tools\Binn with the SA login. Where osql.exe resides!
I don't see its magic powers yet.

Read your first post wrong, sorry, I thought you said it was a named
instance. What directory are you in when you're running the command? It
appears as though either the command is not seeing the OSQL interpreter or
the username and password is incorrect. Are you using the build-in SA
account. It has magic powers, you know.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-

Tried that and still no go. Remeber I am not running a named instance. The
name is "local" so should it be [servername/servername] or
[servername/local] or what? Becasuse I also tried both of these and still no
go! I am stuck like chuck!!!

:

Jay:

upgdb111.cmd [servername] [projectserver] [login] [password]

Should be:

upgdb111.cmd [servername/instancename] [projectserver] [login] [password]


--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-
Everytime I run SP1 I get this error

[DBNETLIB]Specified SQL server not found.
[DBNETLIB]ConnectionOpen (Connect()).

Error encountered while running UPGPJ111.SQL!

I am running SQL server locally and it is not a named instance. I am
logged
into server as an admin with a domain account. The command line I am
running
is
upgdb111.cmd [servername] [projectserver] [login] [password]

Am I doing something wrong here?