We have been running sql server 2008 enterprise on a single networked machine (SBS 2008) which is also runs DHCP and DNS. We have bought a new server to just run SQL Server 2008 and I cannot manage to connect to it via SSMS from my laptop - I can see
the server but not the instance.
Here is roughly what I have done:
Installed Windows Server 2008 Enterprise on the box Installed SQL Server 2008 Enterprise on the box Create a named instance Configured instance to listen on TCP 1533 Created a new firewall rule to allow traffic through on TCP 1533 Created a new rule for sqlsrvr.exe on the firewall
I have the services loging on with the following accounts:
SQL Server Integration Services 10.0 = DOMAIN\dbadmin = running = automatic SQL Server Analysis Services = DOMAIN\dbadmin = running = automatic SQL Server (namedinstance) = DOMAIN\dbadmin = running = automatic SQL Full-text Filter Daemon Launcher = NT AUTHORITY\LocalService = running = manual
SQL Server Reporting Services = NT AUTHORITY\LocalService = running = automatic - this is installed but not configured
SQL Server Agent = DOMAIN\dbadmin = Stopped = manual SQL Server Browser = LocalSystem = running = automatic
When I log onto the new box as a domain user and log into management studio on my laptop I can then suddenly see the instance and connect.
It sounds to me that it is a permissions / acc
View Complete Post