For local connections use [local] as the server name if you chose the default instance name on install, otherwise, use the [computername/instance]
On Sun, Jan 24, 2010 at 12:23 PM, Matthew Smith <chedders...@gmail.com> wrote: > > I have my server configured with a static ip, 192.168.0.3. I can remote > desktop to the box, and connect to sql server locally via management studio. > On my new machine, the one I am remote desktopping from, I am unable to > connect via management studio. I have verified that the server is configured > to accept connection via tcpip and named pipes. > > I get this: > TITLE: Connect to Server > ------------------------------ > > Cannot connect to server. > > ------------------------------ > ADDITIONAL INFORMATION: > > A network-related or instance-specific error occurred while establishing a > connection to SQL Server. The server was not found or was not accessible. > Verify that the instance name is correct and that SQL Server is configured to > allow remote connections. (provider: Named Pipes Provider, error: 40 - Could > not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) > > For help, click: > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476 > > ------------------------------ > BUTTONS: > > OK > ------------------------------ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:311084 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
