Viewing 15 posts - 361 through 375 (of 966 total)
I agree. SQL Server 2000 ended mainstream support years ago. Is the data source you are reporting on based on SQL Server 2000 still? You would be better served trying...
August 7, 2013 at 4:02 am
What happens when you try setting the SQL Agent to a domain account in SQL Server Configuration Manager? Does it succeed or does it give you an error? If it...
August 7, 2013 at 3:13 am
Is there a way I can fulfil client requirements by not clustering SSRS?
I have heard that clustering SSRS is a complex thing to do.
You can't really cluster SSRS. It...
August 6, 2013 at 8:08 am
Once the new clusters are up you can also look at things like db mirroring or log shipping. That way the data is already replicating over to the new instances...
August 6, 2013 at 8:04 am
Is the IP address that reponds to the ping the same IP that you use to successfully connect?
Curious, if you connect to one of these instances by IP name what...
July 31, 2013 at 6:49 am
Glad that you were able to connect. Just a warning though don't leave it running with the /f switch. That puts SQL Server into single-user mode, so other connections will...
July 31, 2013 at 6:41 am
If you can ping the server by name, then DNS is resolving the name, but SQL Server might be configured to allow connections only on a specific port. If...
July 31, 2013 at 6:05 am
So you can successfully ping by server name, or you can't? If you can ping by server name now try connecting by name again in ssms.
July 31, 2013 at 5:41 am
No i cannot ping by the server name but i can ping by ip
Are these servers in a production environment? It sounds like their hostnames are not registered in DNS....
July 31, 2013 at 5:22 am
There could be a lot of things going on. If you double-click on one of your registered servers that are listed by name does it connect successfully? If so I...
July 31, 2013 at 5:12 am
The Microsoft Assessment and Planning Toolkit will go out and find any SQL instances out in an environment.
July 31, 2013 at 5:07 am
That is correct. Database maintenance plans are basically SSIS packages that depend on the SQL Server Agent in order schedule and run the plans. The SQL Server Agent and most...
July 28, 2013 at 2:38 pm
I think as long as the two instances have their own disk resources you will be okay.
July 25, 2013 at 6:22 am
Viewing 15 posts - 361 through 375 (of 966 total)