Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

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!
0
lenivan
Asked:
lenivan
  • 3
  • 2
1 Solution
 
Jared_SCommented:
What version of SQL Server are you running on your Windows 2003 server?
0
 
lenivanAuthor Commented:
SQL Server 2005
0
 
Jared_SCommented:
You could backup the database in 2005, and restore it to 2008. Then if you run the following command against the database it would make your database 08 compatible.

ALTER DATABASE <database>
SET COMPATIBILITY_LEVEL = { 100 }

That would leave the original database in tact.

You could also use the Wizard in 2008 talked about a little here:
http://www.packtpub.com/article/copying-database-sql-2008-copy-database-wizard

Or you could detach the database files from one instance, move them, and attach them on the new instance. (To me, this seems to make the LEAST sense in your situation).
0
 
lenivanAuthor Commented:
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
0
 
Jared_SCommented:
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.
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now