SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Sqlexpress instance name issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hpk
Starting Member

Pakistan
2 Posts

Posted - 09/12/2013 :  20:08:47  Show Profile  Reply with Quote
Hello,

I am facing an issue with my new sql express installation. Previously I had a crystal reports application whose connection string was set with dot (.) as data source and it was working fine.

However after a new installation the connection string is no longer working without using the datasource something like .\sqlexpress OR server\sqlexpress

However the connection string is hard coded and I do not want to change all the connection strings. So can anyone share a fix to this problem?

Thanks.

ahmeds08
Aged Yak Warrior

India
534 Posts

Posted - 09/13/2013 :  06:15:26  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
what does the name column display in sys.servers table

mohammad.javeed.ahmed@gmail.com
Go to Top of Page

hpk
Starting Member

Pakistan
2 Posts

Posted - 09/13/2013 :  14:21:01  Show Profile  Reply with Quote
It is currently saying:

SRV/SQLEXPRESS

Thanks.

Imran
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 09/13/2013 :  14:33:57  Show Profile  Reply with Quote
As far as I know, it is not easy nor recommended to rename a server, notwithstanding blogs and other articles that say that you can - for example here: http://www.modhul.com/2008/01/15/renaming-a-sql-server-instance/


One possible approach you might want to consider is creating an alias for the server. However, this is a client-side things, so you will need to do this on each client that wants to use the alias. http://technet.microsoft.com/en-us/library/ms190445.aspx
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000