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: 260
  • Last Modified:

SQl Server new Install

Hi, I have upgraded SBS 2003 to SBS 2011 but having a problem getting the software to connect to the databases. Have restored the databases in to SQL Express and they look fine but the software wont connect because the old databases were \\servername\database but now are \\servername\mssql\database, can I reconfigure SQL so there is no \mssql or \sqlexpress ? The ini files point straight to \\servername and I have tried changing them.

Hope you can help and this isn't too garbled !
0
PeterNairn
Asked:
PeterNairn
  • 4
  • 3
1 Solution
 
SylvainSSiriCommented:
I think you will have to connect with the mysql manager provided when you installed/upgraded.I know you can install SQL Server Management Studio to manage it of course.It has a nice gui and it should be rather simple to change to whatever you want.
What is the method you use to authenticate to it?
0
 
PeterNairnAuthor Commented:
Hi, I have connected with Management studio and restored the databases, problem is software is configured to connect with the path \\servername\ but now it's \\servername\sqlexpress.
0
 
SylvainSSiriCommented:
Did you try to reinstall and rename it?
I have found a website which could help since the management studio doesn't help you.
http://dba.stackexchange.com/questions/22002/how-to-change-the-instance-name-of-sql-server-express-2008

I hope it will help!¸
In my case I didn't mind that it was called sqlexpress, but seems it's not supposed to be like that...(I had to install it and manage it at my work's place since they need it for programming,so if you have other questions,I will try to help you)
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
SylvainSSiriCommented:
You will have to delete it completely and reinstall with the instructions provided in the link.If it does not work,tell me!
0
 
PeterNairnAuthor Commented:
The problem is you have to name it , on the old server it wasn't named in the ini files. I shall look at link in the morning and let you know , thanks
0
 
PeterNairnAuthor Commented:
Thanks for the help Sylvain but I had to create a new Instance and call it the same name as the server, this will then give you the same configuration and path as the old sql 2005.
0
 
PeterNairnAuthor Commented:
No one else was aware of the solution
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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