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.
| 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\sqlexpressHowever 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 tablemohammad.javeed.ahmed@gmail.com |
 |
|
|
hpk
Starting Member
2 Posts |
Posted - 2013-09-13 : 14:21:01
|
| It is currently saying:SRV/SQLEXPRESSThanks.Imran |
|
|
|
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 |
|
|
|
|
|
|
Sqlexpress instance name issue