Need help with a SQL application
Megadeth4168
Member Posts: 2,157
in Off-Topic
OK, here's the deal, I have a server that is running SQL server 7 and SQL server 2005 Express edition. What I want to do is move a database from one of our other server that we are decommissioning. This other Database is currently on a server using MSDE.
Now, I have had no issues attaching the database to either SQL instance. However, when I attempt to install the server side software on the "new" server I get an error that says
"Program has detected SQL server 2000 installed on this machine, cannot locate the default instance, this program cannot use named instances"
Problem is, I am using the default instance for SQL 7.... I'm wondering if it is ignoring the fact that SQL 7 is installed and trying to find the Named instance for the SQL express... (Servername\SQLEXPRESS)
SQL is not one of my strong points...I think I know just enough to be dangerous. Any help would be appreciated. Thanks.
Now, I have had no issues attaching the database to either SQL instance. However, when I attempt to install the server side software on the "new" server I get an error that says
"Program has detected SQL server 2000 installed on this machine, cannot locate the default instance, this program cannot use named instances"
Problem is, I am using the default instance for SQL 7.... I'm wondering if it is ignoring the fact that SQL 7 is installed and trying to find the Named instance for the SQL express... (Servername\SQLEXPRESS)
SQL is not one of my strong points...I think I know just enough to be dangerous. Any help would be appreciated. Thanks.