Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pubs database not installing for newbie

Status
Not open for further replies.

diwin

Technical User
Nov 29, 2002
218
CA
I am new to this stuff. Where am I going wrong?

I successfully installed MSDE for use with VS.net 2003 using...

Code:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=mycurrentadminpw

However, I cannot install the pubs database. When I use the following command, there is a delay of about 20 seconds and the c:\ prompt displays. There is no other message. When I check the MSSQL$VSDOTNET directory, pubs is not there.

Code:
OSQL.EXE -E -S mycurrentcomputername\VSDOTNET -i "C:\SQL Server 2000 Sample Databases\instpubs.sql" -o C:\instpubs.out

Daniel Dillon
O o . (<--- brain shrinking at rate shown.)
 
Solution:

When I click on My Computer and select the "Computer Name" tab, I can read the computer's name. This makes sense. The last character in the name happens to be a period, "." The period is, however, not a character in the name. So why is it there??????? I only spotted it when I became suspicious of the period and clicked on the Change button to rename the computer. The name displayed there without the period.

That's it. PERIOD!

Daniel Dillon
O o . (<--- brain shrinking at rate shown.)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top