Re: Connecting to SQL Express 2005

The Host Name is the name of the PC's present name. Keep in mind I have
installed SQL 2005 Express on the renamed PC. My application connects on that
specific machine but not on others trying to connect to the renamed PC. I
have come across this before and after many hours struggle found the
"renaming problem" however you don't always know what the original name was
to change it back.

"Miro" wrote:

If you run the SQL servier Configuration manager,

Click on SQL Server 2005 Services,
and then go to properties to ( for example ) "SQL Server Integration
Services"
click on the Service tab,
what does it say under "Host Name"?

Miro

"Connull" <Connull@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1139EBDA-DA70-4421-B426-1EFCABD0FAD2@xxxxxxxxxxxxxxxx
I have developed a windows app which uses a SQL database. I have discovered
that if you install SQL Express 2005 on a PC which has been renamed you
cannot access the SQL Server from the application (SQL Server not found or
access denied). Should you be lucky to know what the original name was of
the
particular PC and rename it back to this the application can then connect.
The problem I am experiencing is that when I deploy or install my
application
on a Client's PC sometimes the PC's have been renamed and they don't know
the
original namiing. Has anyone experienced this problem? Is there a
solution?
Is there a way of identifying the PC's original name? All help will be
appreciated as this has become a major stepping block in my rollouts.


.

Relevant Pages

  • Re: Rename SQL Server Virtual name in 2003 Cluster
    ... The ONLY SUPPORTED way to rename a virtual SQL name is to uninstall and reinstall as documented in Microsoft Knowledge Base article ... How to Change a Clustered SQL Server Network Name ... "Cluster Administrator provides a method to rename cluster resources. ...
    (microsoft.public.sqlserver.clustering)
  • Re: microsoft sql, excel/access data transfer problems
    ... I don't use the MS tools, but if it's the field name causing the problem then you could try delimiting the field name "CU#">500 or creating an LF or View to rename the fields. ... An SQL View is equivalent to a non-keyed LF. ... This Redbook would be a good resource to learn about SQL vs DDS: ... It gives me an error (Query wizard cannot join ...
    (comp.sys.ibm.as400.misc)
  • using a value from a table as argument of rename
    ... I need to rename a file from inside a SQL job, reading a value from a sql table as an argument of the rename command. ... the trick with xp_cmdshell is not disabling it but securing it (e.g. ...
    (microsoft.public.sqlserver.programming)
  • Re: Renaming Computer Running SQL or MSDE
    ... Thanks for the response Jim, but earlier versions of MSDE and SQL ... >> to suspect that it is permissible to rename a computer that is running ...
    (microsoft.public.sqlserver.msde)
  • Re: SBS Sharepoint Problems
    ... I have not installed SQL on it's ... Sharepoint Site i am told to go to Sharepoint Central ... I was assuming that using MSDE it was all done for me... ...
    (microsoft.public.windows.server.sbs)
Loading