January 4, 2012 at 11:43 pm
hi
i using sql server 2008 in my local machine..in my window server i installed sql server 2008 R2..when i try to connect that window server (sql server) in my local machine (window xp) its shows error like
cannot connect to <server_name>
Addition information:
Timeout expired..the timeout period elapsed prior to completion of the operation or the server is not responding
January 4, 2012 at 11:50 pm
By default SQL Server does not allow remote connections. You need to enable remote connections.
January 5, 2012 at 12:13 am
ya thanks for ur reply shall u plz tell me briefly how to enable that connection
January 5, 2012 at 12:48 am
EXEC sys.sp_configure N'remote access', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply