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'.
...
- 13
0
votes
1
answer
36
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
2k
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
123
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
247
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
568
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 (...
- 509
1
vote
1
answer
551
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
668
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
394
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
74
votes
2
answers
220k
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,813
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
729
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
0
votes
1
answer
5k
views
Updating MS SQL Server from 10.50.1600 to 10.50.1617
How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617?
I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
0
votes
1
answer
314
views
Creating a database in Visual Basic 2010 Express
I'm studying computing and I need to make a program for my project. My project is a fast food ordering system which needs a database. While trying to add a SQL Service Database I get an error message ...
- 1
0
votes
1
answer
181
views
How to share a SQL Server 2008 Standard edition database to another on a computer (wireless network)
Does anyone know how to set the properties of database to be shared through wifi network? I'm running windows 8.1 OS and the other computer I need to share with, is Windows 7. I tried to use 'adhoc' ...
4
votes
1
answer
3k
views
SQL Installation hanging on windows 10
I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2).
Everythings hangs, and always at this point.
I've a feeling its a .net related issue ...
- 151
0
votes
1
answer
960
views
Time and date filter in SSRS 2008
I am looking for an expression that can filter a time and date column to 4 hrs prior from what the actual value is.
Example: 5/27/2015
5:00:30 pm
So I am looking how to get: 5/27/2015
...
- 43
4
votes
3
answers
35k
views
SQL Server not working after upgrading windows 10 from windows 8.1
My Sql server 2012 has stopped working and now its not letting me login. Here is the error:
https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing
TITLE: Connect to Server
...
- 563
0
votes
1
answer
1k
views
Can't install SQL server 2008 or SQL Server 2014
When I try to run the SQL SERVER 2008 setup, it shows the following error and exits:
SQL Server Setup has encountered the following error:
Unable to cast object of type
'System.Configuration....
- 101
2
votes
1
answer
221
views
How to pick rows in MS SQL based on column values?
I want to pick SourceId & Currency based on Count value. Problem is within a set I've to ignore all data where Count = 0 if there is any value greater than 0 but if all the counts are 0 within a ...
- 21
2
votes
2
answers
819
views
Cannot uninstall SQL Server 2008 from Windows Server 2012 r2
I have install SQL Server 2008(64-bit) express on the virtualbox in virtual machine, with guest os Windows Server 2012 R2(It is also domain controller). After the installation, I decide I would like ...
- 121
0
votes
1
answer
66
views
SQL server connects after browser restart
I am using SQL server 2008 trying to connect the server using management studio using ssms with server name including ports and named instance with SQl authentication . Windows firewall is disabled .
...
- 813
0
votes
1
answer
91
views
SQL Server 2008 Backup to networked drive
When I go to backup a SQL database - I only see options to do the backup on a local disk.
Is it possible to backup to a network drive directly?
- 199
0
votes
1
answer
525
views
Mysql Connector crash on SQL Server 2008
I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL ...
- 1
0
votes
0
answers
58
views
Change SQL server back to a trial
I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial.
What are the steps to do this?
REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
- 2,963
1
vote
1
answer
844
views
Move SQL Server 2008 to virtual machine
I have a physical server that uses SQL server 2008 in managing my warehouse.
We desperately want to virtualize this server.
Would I need to buy a new SQL server license? Or is there a way to use ...
- 135
0
votes
1
answer
334
views
sql server 2008 Management Studio does not see my copied database
I copied my database (mdf and ldf files) from my server to the cloud. Previously I have done it from one local server to another. I put it in the same directory (MSQLSERVER/../../data, confirmed that ...
1
vote
1
answer
373
views
SSMS view designer - how do I give a table an alias?
I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible.
Case in ...
- 930
1
vote
1
answer
12k
views
Remove column header from sql query output in powershell
I want to remove column header from sql server query output. I did the search but not found any solution. I have a script.
$Database = "temp"
$Server = "localhost"
$AttachmentPath = "output.csv"
# ...
- 320
0
votes
1
answer
81
views
MS SQL Server 2012 drives
I am buying machine for MS SQL Server 2012 Standard and I have questions about drives and performance.
How to locate OS, database, logs, backup on WD RE4 500GB and Intel SSD DC S3500 120GB?
OS, logs ...
- 1
2
votes
2
answers
2k
views
Try to resolve logged error SQL Server/SQL Server 2008 R2
I have this logged error #10016
The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID
{46063B1E-BE4A-4014-8755-...
- 175
2
votes
1
answer
11k
views
Is SQLCMD part of the DB Engine or Client Tools?
We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
- 338
1
vote
1
answer
161
views
SSMS 2008 is stuck because Connect to Server window is hiding
Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
- 125
1
vote
2
answers
11k
views
How to start/open SQL Server Express 2008 in Visual Studio?
I have Windows 8 and have installed full-pack Microsoft Visual Studio 2010 Ultimate Edition. There was no error while installing Visual Studio 2010 Ultimate Edition.
I exactly don't know which ...
- 111
3
votes
1
answer
456
views
Install sql server management studio API only
I have already installed sql server 2008 R2 , but now i need to install sql server management studio also ( i mean just that API ony ) is it possible to install only this instead of uninstall sql ...
- 31
0
votes
1
answer
187
views
Move multiple SQL Server 2008 databases from C: to D: at once
I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD.
Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive.
I have ...
- 602
0
votes
1
answer
427
views
Error when install SQL server 2008 the application was unable to start correctly (0xc0007b)
"the application was unable to start correctly (0xc0007b).click ok or close button to installing application)"
Error come when i try to install SQL server 2008 in my system.
How can i fix this error?...
6
votes
1
answer
3k
views
SQL Server ODBC authentication errors
I'm trying to connect to a SQL Server 2008 database from a 3rd-party application through an ODBC connection. I am having success when the ODBC is set up with Windows Authentication but not when it's ...
- 498
1
vote
1
answer
1k
views
SQL server replication, subscription to remote server : issue while choosing the publisher
I am trying to create a subscription to a remote server having SQL 2008 R2
the client PC is connected through VPN to the server and can discover it successfully.
I can even connect to the database ...
- 36
0
votes
1
answer
163
views
Windows XP, SQL Express, 3rd party application crash -- how to check the possible lack of resources?
Summary: I need to log usage of resources on Windows XP machine to find if the lack of resources may be the reason for the application crash. I need your advice how to do that.
Context: There is an ...
- 119
0
votes
1
answer
6k
views
How to un-install sql server 2008 analysis service only?
Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
0
votes
2
answers
4k
views
Can I delete SQL Server from Windows 7 without secondary effects?
I'm trying to delete all unnecesary programs from my computer and SQL makes me doubt. I don't use it directly, but can't recall any program using it. Is it safe uninstalling?
- 170
11
votes
3
answers
1k
views
How to install multiple Microsoft applications without conflicts
For all the IT students, self-teachers, and new professionals
Situation: The days of ...
- 850
0
votes
1
answer
57
views
SQL Server 2008 Express, just create a few tables and run queries? [closed]
I have installed SQL Server 2008 Express, as I just want to create a few tables and run queries against them. After installing I am a little unstuck. I have an "instance" running, but I am not sure ...
- 187
1
vote
2
answers
1k
views
How to install Sql 2012 on Windows 8?
I am having trouble installing sql server 2012 on windows 8.
- 1,949
1
vote
1
answer
450
views
SQL Server 2008 R2 service pack 1 not showing
I've checked my SQL server version and it says "Microsoft SQL Server Management Studio 10.50.1600.1". I've seen here that there's a SP1 for it. Why doesn't windows update offer me to d/l it?
Should I ...
- 111
8
votes
2
answers
15k
views
Sql Server Management Studio: Change Prefix or Suffix characters
I have an instance of SSMS 2008, for which the option to edit data in a table doesn't work. If I right-click on any table in the Object Explorer and select 'Edit top 200 rows' I get an error dialog '...
- 999