Questions tagged [sql-server-2008]
Microsoft SQL Server, commonly referred to as simply "SQL Server," is the relational database engine developed by Microsoft. MS SQL Server 2008 was released on August 6th, 2008, and is major version 10 of the application.
144
questions
0
votes
0
answers
2k
views
Reporting services configuration manager cannot find Report Server instance (SQL server 2008 R2 standard)
I have SSRS and SQL server 2008 running on same server. However sometime I found Reporting services configuration manager cannot find Report Server instance and it is affecting reports.
The only way ...
1
vote
1
answer
2k
views
SQL Sever Management Studio 2008 does not let me back up my database
I tried to back up a server I created in SQL Server, but I received the following message:
TITLE: Microsoft SQL Server Management Studio
Backup failed for Server 'LAPTOP-6D0L83DV\SQLEXPRESS'.
...
- 113
0
votes
1
answer
41
views
using Sql Management Studio 2008 list past connections
when you open up sql management studio you can select server, and get a list of remembered connections. I don't care about getting pw and but I would like a list of remembered or past connections. ...
- 1
1
vote
0
answers
32
views
What does it mean "Microsoft SQL 2010 R2" as an application requirement?
I have this terrible doubt of windows and hope someone of you might know what is it.
I bought a contability software (here in mexico there are few providers cause they are regulated), the thing is ...
- 111
1
vote
1
answer
3k
views
How to reduce the database size of MS SQL server
I have a website that runs on MS SQL Server 2014 Enterprise with two clustered virtual machines and AlwaysOn. A database backup is created each night and the size is now 20GB.
On my laptop, I also ...
- 161
0
votes
0
answers
135
views
SQL Server 2008 SA account locked
Trying to access SQL Server 2008 database of production server but admin and SA account was not accepting it.
After trying several time SA account is locked. How to unlock it without any production ...
1
vote
1
answer
255
views
PHP Query to SQL Server through IIS 7.0 on Windows Server 2008 R2
So I am building a webpage on my Windows Server 2008 R2, I have IIS 7 configured to work on the intranet so I can access the site locally from any machine within my Active Directory/Local Network. ...
- 131
2
votes
0
answers
586
views
SQL Server Express no longer starts up automatically
I had SQL Server 2008 Express (SP1) on Windows 7 Pro and it was working fine.
After upgrading to Windows 10, SQL Server 2008 Express was still working normally.
However, after the last Windows update (...
- 519
1
vote
1
answer
564
views
How to schedule a recurring SQL Server 2012 DB backup using sqlcmd ?
I'm looking for a way to create a monthly recurring backup of a SQL server database using sqlcmd.
I've seen scripts for SQL Express, but they only execute once. I'm looking for a sql script that will ...
- 201
3
votes
1
answer
679
views
Permission to query WMI
I have a project to remove admin rights from our users. An application we use, during upgrades, runs a query against WMI:
Namespace: root\Microsoft\sqlserver\computermanagement10
Class: ...
- 93
2
votes
2
answers
3k
views
SQL : Restrict view of tables in database
This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
- 21
3
votes
1
answer
404
views
Can't list SQL databases like directories with PowerShell
I'm trying to list databases with PowerShell. I'm able to use Inkoke-Sqcmd cmdlet, but I can't list databases with this command:
dir SQLSERVER:\SQL\myserver\sqlinstance\Databases
Get-ChildItem : No ...
- 157
75
votes
2
answers
223k
views
Where is SQL Configuration Manager in Windows 10?
I just have upgraded to Windows 10. I can't find SQL Server Configuration Manager. I have MSSQL 2008 and 2014 installed but there is no configuration manager in "All Apps".
This is just a picture of ...
- 2,823
0
votes
0
answers
3k
views
Unable to connect to sql server 2012 with SSL encryption enabled using sqljdbc4
I am trying to connect my web application to SQL server 2012 with SSL encryption enabled using sqljdbc4 but i get the below error :
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could ...
- 123
1
vote
0
answers
734
views
Cannot install SQL Server 2008 R2 express. Compiler returned error 0x8007005
First off, I'm having a very similar issue to this StackOverflow post here: https://stackoverflow.com/questions/31681386/sql-server-configuration-manager-wont-start-wmi-returns-error#
Installing SQL ...
- 111