Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Sqlexpress instance name issue

Author  Topic 

hpk
Starting Member

2 Posts

Posted - 2013-09-12 : 20:08:47
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

737 Posts

Posted - 2013-09-13 : 06:15:26
what does the name column display in sys.servers table

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

hpk
Starting Member

2 Posts

Posted - 2013-09-13 : 14:21:01
It is currently saying:

SRV/SQLEXPRESS

Thanks.

Imran
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-13 : 14:33:57
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
   

- Advertisement -