Right-click the Security folder, point to New, and then click User.
In SQL Server Management Studio, open Databases folder, expand testDB.
SQL MANAGEMENT STUDIO 2008 R2 CONNECT TO REMOTE DATABASE PASSWORD
Confirm User must change password at next login is not selected.
In general, enforcing password policy is the more secure option.
Select the Enforce password policy and Enforece password expiration options.
Select 'sql server network configuration\protocols for MSSQLServer\SQLExpress'.
On the General page, enter a name for the new login in the Login name box. First, in management studio, check management, sql server logs\current - you want to search for a message saying 'Server is listening on 'any' 1433.' If not, go to start, all programs, SQL server 2008, configuration tools, sql server configuration manager.
Right-click the Security folder, point to New, and then click Login.
In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
To create a SQL Server login that uses SQL Server Authentication (SQL Server Management Studio):
Select the From device, and point the testDB.bak file location.
Enter database name into To database section.
In SQL Server Management Studio, Right-click the Databases folder, Click the Restore Database.
Select Allow the connection, click next button, again click next button.
Click Change settings link, point to Exceptions tab.
SQL MANAGEMENT STUDIO 2008 R2 CONNECT TO REMOTE DATABASE WINDOWS
Click Start, point to Control Panel, point to Windows Firewall Settings.
Open TCP/IP Properties form using right mouse click over TCP/IP, point to IP Address tab, point to TCP Port in Last section, change TCP Port to 1433, and click Apply button.
Click SQL Server Network Configuration, point to Protocols for SQLEXPRESS, point to TCP/IP, make sure TCP/IP status is Enabled.
Restart the SQL Server( SQLEXPRESS) using right mouse click over SQL Server(SQLEXPRESS).
If SQL Server Browser is stopped, then select its properties and point to Service tab, change the Start Mode Disabled to Automatic, click the apply button, then click start option using right mouse click over SQL Server Browser.
Click SQL Server Services, make confirm SQL Server (SQLEXPRESS) and SQL Server Browser running.
Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
SQL Server 2008 to allow remote connections
In Authentication Mode page, please select the Windows Authentication Mode.
In Instance Name page, please select the Default instance.
Database Management Tool: SQL Server Management StudioĬonfiguration Steps SQL Server 2008 R2 Installation.
Database System: SQL Server 2008 R2 (preferable) / SQL Server 2008.
SQL MANAGEMENT STUDIO 2008 R2 CONNECT TO REMOTE DATABASE WINDOWS 7
Operating System: Windows 7 (preferable) / Windows Server 2008 standard.
In this article, the configuration steps for remotely accessing SQL Server 2008 R2 using Java are described.
0 kommentar(er)
