How to create Database connection?
Hi,
I am wondering how to make connection with the database I have selected, please provide me some guides about how to make connection with less complexities, I have a portal and a Database at Backend, I am little bit confused where to starts from.
Thank, any help would be appreciated.
Re: How to create Database connection?
To make a connection with database follow the steps:
- Click New Connection.
- The Connection Properties dialog box appears.
- In Server Name, type or click the name of the server to which you want to connect.
- To use your Microsoft Windows credentials to log on to the server, click Use Windows Authentication.
- To use SQL Server authentication to log on to the server, click Use SQL Server Authentication, and then type your user name and password in User name and Password.
- In Connect to a Database, type or click the name of the database to which you want to connect.
- (optional) You can click Advanced to configure advanced connection properties.
- (optional) You can click Test Connection to verify that you can connect to the database by using the specified connection information.
- Click OK to create the connection.
Hope this solve your problem.
Re: How to create Database connection?