-
as seen on Server Fault
- Search for 'Server Fault'
I would like to set a password and username for connecting to a server with SQL Management Studio 2008.
I set up SQL Server 2008 Express on a customer's computer to host a DB used by an Access 2007 app. The customer should not be able to access the DB or connect with SQL Management Studio.
How do…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says:
Reporting Services Configuration Manager
An unknown error has occurred in the WMI Provider. Error Code 800706B3
This error appears before I can even attempt to connect to an SSRS instance.
In…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following steps below and am beyond any further ideas. I have researched the site and cannot figure anything else…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the schedule just added... what am I missing? (I'm using the right job_name param, etc) thanks!
BEGIN TRY
BEGIN…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
An external consult wrote a guide on how to copy a database. Step two was detach the database using Sql Server Manager. After the detach the database was not visible in the SQL Server Manager...
Not much to do but write a mail to the service provider asking to have the database attached again. The…
>>> More