After Re-installing SQL Server, App Did Not Work

Feb 9, 2005

For some reasons, I uninstalled and reinstalled SQL server in local pc. Now, none of my app is working. My pc is XP professional with sp2 and VS.NET is 2003.

I spent a couple of days but no luck. It drived me crazy!

Help!!!

View 3 Replies

Installing Northwind Database By Instnwnd.sql Does Not Work?!

Dec 1, 2007

Hi all,

I downloaded the Northwind database install script (SQL2000SampleDb.msi) and ran instnwnd.sql in my SQL Server Management Studio Express. I got the following error messages:

Msg 5105, Level 16, State 2, Line 1

A file activation error occurred. The physical file name 'northwnd.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Msg 1802, Level 16, State 1, Line 1

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Msg 15010, Level 16, State 1, Procedure sp_dboption, Line 64

The database 'Northwind' does not exist. Use sp_helpdb to show available databases.

Msg 15010, Level 16, State 1, Procedure sp_dboption, Line 64

The database 'Northwind' does not exist. Use sp_helpdb to show available databases.

Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'Northwind'. No entry found with that name. Make sure that the name is entered correctly.

Msg 3726, Level 16, State 1, Line 2

Could not drop object 'dbo.Customers' because it is referenced by a FOREIGN KEY constraint.

Msg 3726, Level 16, State 1, Line 2

Could not drop object 'dbo.Employees' because it is referenced by a FOREIGN KEY constraint.

Msg 2714, Level 16, State 6, Line 1

There is already an object named 'Employees' in the database.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'LastName' already exists on table 'dbo.Employees'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'PostalCode' already exists on table 'dbo.Employees'.

Msg 2714, Level 16, State 6, Line 1

There is already an object named 'Customers' in the database.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'City' already exists on table 'dbo.Customers'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'CompanyName' already exists on table 'dbo.Customers'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'PostalCode' already exists on table 'dbo.Customers'.

Msg 1913, Level 16, State 1, Line 1

The operation failed because an index or statistics with name 'Region' already exists on table 'dbo.Customers'.

(1 row(s) affected)

............................................etc.

Please help and advise me how to get the Northwind database installed in my SQL Server Management Studio Express.

Thanks in advance,
Scott Chang

View 6 Replies View Related

My Connection String Doesn't Work After Installing WinXP Sp2

Mar 13, 2005

Hi all,
Recently i have installed (winxp sp2) and i have encountered with some
problems, for example i always use the following Connection string for
connecting to SqlServer 2000 and work with it:

"Server=localhost;database=Test;Trusted_Connection=yes"

But now this string doesn't work and after some minutes i found out the solution as follows:

"Server=MYPCNAME;database=Test;Trusted_Connection=yes"

or

"Server=(local);database=Test;Trusted_Connection=yes"

or

"Server=.;database=Test;Trusted_Connection=yes"

(Note that my computer name really is "MYPCNAME")

Between three above solutions i want to know why "Server=MYPCNAME" work properly

BUT "Server=localhost" doesn't work after installing WinXP SP2.

Thanks in advanced.