Solved

SQl Server new Install

Posted on 2013-05-26
7
249 Views
Last Modified: 2013-06-02
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
Comment
Question by:PeterNairn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 1

Expert Comment

by:SylvainSSiri
ID: 39198082
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
 

Author Comment

by:PeterNairn
ID: 39198086
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
 
LVL 1

Expert Comment

by:SylvainSSiri
ID: 39198092
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 1

Expert Comment

by:SylvainSSiri
ID: 39198093
You will have to delete it completely and reinstall with the instructions provided in the link.If it does not work,tell me!
0
 

Author Comment

by:PeterNairn
ID: 39198105
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
 

Accepted Solution

by:
PeterNairn earned 0 total points
ID: 39202831
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
 

Author Closing Comment

by:PeterNairn
ID: 39214117
No one else was aware of the solution
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question