lenivan
asked on
Need help setting up SQL Server Instance/Database
I'm a complete newbie to SQL, but here's my issue.
I'm running Desktop Authority on a Windows 2003 server. I need to move it's database to another server. On the new target server, I'm running Server 2008 and have SQL Server 2008 installed.
I think I need a new instance or database installed on the target server so that the original server and Dekstop Authority can see it. How do I do that? I don't have a clue where to begin. Please help!
I'm running Desktop Authority on a Windows 2003 server. I need to move it's database to another server. On the new target server, I'm running Server 2008 and have SQL Server 2008 installed.
I think I need a new instance or database installed on the target server so that the original server and Dekstop Authority can see it. How do I do that? I don't have a clue where to begin. Please help!
What version of SQL Server are you running on your Windows 2003 server?
ASKER
SQL Server 2005
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will try the suggestions you posted.
Additionaly, while in Desktop Authority on Server 2003, I try to connect to a database on my target server and recieve an error message. I've attached a screen shot. Does this tell you anything to point me in the right direction?
error.jpg
Additionaly, while in Desktop Authority on Server 2003, I try to connect to a database on my target server and recieve an error message. I've attached a screen shot. Does this tell you anything to point me in the right direction?
error.jpg
All I can tell is that you're having some issues connecting to the new SQL Server from Desktop Authority.
SQL Server 2008 is probably installed as an unnamed or default instance. If that's the case you should only need the server name to connect (Rather than <server name>\<instance name>).
I don't have any experience with Desktop Authority (does it try to connect to a specific database?), so I can't offer much help how to change the database connection settings.
A sql connection is generally made up of the server name (and possibly instance name), user authentication, and possibly a database name.
You might try connecting with SSMS, or an SSMS alternative that will establish a connection to the sql server without trying to connect to a single database to help start narrowing down the problem with the connection.
I wish I could be more help with that error.
SQL Server 2008 is probably installed as an unnamed or default instance. If that's the case you should only need the server name to connect (Rather than <server name>\<instance name>).
I don't have any experience with Desktop Authority (does it try to connect to a specific database?), so I can't offer much help how to change the database connection settings.
A sql connection is generally made up of the server name (and possibly instance name), user authentication, and possibly a database name.
You might try connecting with SSMS, or an SSMS alternative that will establish a connection to the sql server without trying to connect to a single database to help start narrowing down the problem with the connection.
I wish I could be more help with that error.