Life On Network

Life On Network – IT Support

SQL Server

User Group or Role already exists in the current database

User, Group, or Role already exists in the current database. (Microsoft SQL Server, Error: 15023) While after restoring the database I just created the users in the new server and then trying to map to the restored databases …. I got an error like User, Group, or Role already exists in the current database… ūüôĀ More

2,967 total views, 12 views today

Create a rule in Windows Firewall to give access to connect Microsoft SQL Server

Create a rule in Windows Firewall to give access to connect Microsoft SQL Server On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type dialog box, select Port, and then click Next. In the Protocol and Ports dialog box, select TCP. More

3,929 total views, 2 views today

Enable and change FILESTREAM Setting SQL Server 2008 R2 Express

When you are trying to restore one database and you stuck with the error showing FileSTREAM feature is disabled.   Solution To enable and change FILESTREAM settings     On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.     More

3,114 total views, 1 views today

Connect to the SQL Server 2008 Express remotely

Steps to configure Open SQL Server Configuration Manager. Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager. On SQL Server Configuration Manager, select SQL Server Services on the left window. If the state on SQL Server Browser is not running, you have to configure and start the More

2,315 total views, 6 views today