December 5, 2008 at 4:37 am
Basically we are installing our SharePoint development environment on virtual web front end and a virtual SQL 2005 server.
We would like to use a SQL an Alias so that we can easily move to physical hardware if we have issues with virtual.
I have followed an article on the creation which seemed simple: -
SQL Configuration Manager>SQL Native Client Configuration
Right click Aliases >new Alias
Settings: -
TSharePoint
ServerName: xxxxxxx
TCP
Port: xxxx
I would then expect that during the SharePoint installation the server name should be: TSharePoint
This however fails to be found...
Any Ideas where I have gone wrong?
December 5, 2008 at 6:23 am
on the server you are running the installation from if you do this from a command prompt:
sqlcmd -E -S TSharePoint
does it connect or give you an error?
December 5, 2008 at 7:31 am
I get the command is not recognised
C:\Documents and Settings\IPB_TMOSSInstall>sqlcmd -E -S TSharePoint
'sqlcmd' is not recognized as an internal or external command,
operable program or batch file.
December 5, 2008 at 8:05 am
ok you don't have the sql client tools installed so that didn't help!
Can you instead try and create a system dsn (control panel-->admin tools-->Data Sources (odbc)) - make sure it is a sql server or sql native client and for the server name use the alias.
Does this let you connect?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply