The sql-server-2008 tag has no wiki summary.
0
votes
1answer
74 views
SQL Server 2008 Registration with Product Key
A colleague of mine gave me the SQL Server 2008 Standard ISO image and I used that while building a Virtual Machine.
Now, when I installed SQL Server with that above mentioned ISO, I did not give it ...
0
votes
2answers
28 views
Error while installing SQL Server 2008 on Windows 7 Home Edition 64 bit
I am trying to install SQL Server 2008 on my Windows 7 Home Edition,
Setup is giving an error
attempting to perform unauthorized operation
0
votes
0answers
39 views
how to access database in SQL server from ASP website? [closed]
I was trying to connect database from SQL Server 2008.
the error shown is:
Cannot open database "signature" requested by the login. The login failed.
Login failed for user 'IIS ...
0
votes
0answers
44 views
Data Encryption in sqlserver 2008
My company uses laptop to Enroll customers in the remote villages.
At the end of each business day the records are sync to the Central Database(SQLSERVER 2008).
I want to Encrypt all the column in my ...
0
votes
1answer
94 views
Why don't I have SQL Profiler on SQL Server Management Studio?
I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 ))
However I cannot find the option to open SQL Profiler.
I was ...
-1
votes
1answer
55 views
How to access a website created using ASP.NET with database SQL Server 2008 from another machine? [closed]
I've created package of websites, which redirect to each other, using ASP.NET in C# using Visual Studio and have stored the values in a database using SQL SERVER 2008. I want to make one ...
1
vote
0answers
52 views
Excel 2010 not displaying calculated measures as currency
When connecting Excel 2010 to a SSAS 2008 R2 datasource, calculated fields(Standard Margin) do not display with the appropriate currency symbol. When I define the measures in the cube, I am setting ...
0
votes
1answer
85 views
Microsoft Update - how to make it work properly?
I`m using a wide range of microsoft products - Windows 7 Ultimate x64 with SP1 included, Microsoft Project, SQL Server 2008 R2 and Visual Studio 2010. After doing a full OS reinstall I tried using ...
0
votes
2answers
116 views
Windows 2008 R2 Memory is always full
We have a Windows 2008 R2 on a HP Server with 24GB of RAM. The only important software installed is SQL Server 2008 R2 and almost no feature or role is enabled on this Windows.
But the problem is ...
0
votes
0answers
86 views
Export MS SQL database as *.dbschema
We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
1
vote
1answer
102 views
SQL server 2008 and 2012 on the same instance of Windows
Is it a problem to have both of these installed on the same Windows instance? I.e. will one break the other or impact it negatively in any way?
0
votes
2answers
36 views
I need more advice on this data addition issue
I have a test program consisting of a textbox (textbox1), a button (save), and a connection to a database and a table called TestDatabase.mdf and TestTable (respectively). I am trying to save the text ...
1
vote
2answers
193 views
Lagging windows and mouse pointer in Windows 7
I'm using Windows 7 and on top of it I have installed Visual Studio 2010 and SQL server.
For some time now I have been experiencing a laggy behavior. Explorer windows minimize and maximize with a ...
1
vote
1answer
44 views
How do I set up a new database with SQL Server 2008?
In my start menu, I have Microsoft SQL Server Express 2008 R2 > Configuration Tools. In this folder, I have SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server ...
0
votes
1answer
238 views
Trouble enabling remote connections to SQL Server Express 2008 R2
I'm trying to enable remote connections but i'm having some trouble. Here's my setup
SQL Express is installed on Win2k8 R2.
Windows firewall turned off
SQL Browser service started and running
SQL ...
1
vote
0answers
138 views
Creating a New Database Across a Network with SQL Server 2008 R2
I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and ...
0
votes
1answer
58 views
Install issue in windows 7 SQL Server 2008
I keep trying to install SQL Server 2008 on windows 7 but after a while and more than half installation i get this error:
0
votes
1answer
59 views
SQL Server Reporting?
I have a SQL Server instance setup, and on one of the databases I have a lot of views defined.
I have to connect to our VPN before I can connect to the database.
I'm wondering if there is a simple ...
1
vote
1answer
146 views
What basic linux command-line utility can I use to test a JDBC connection?
I'm troubleshooting an issue with importing data to Apache Solr from a MS SQL Server database via a JDBC connection. Solr is hosted on a CentOS linux machine, and SQL Server is (of course) on a ...
0
votes
1answer
206 views
What's the difference between single processor or dual processor SQL Server 2008? [closed]
I am little bit confused about single core processor based SQL server or dual processor based SQL server.
We are planning to purchase SQL server 2008 Standard R2.
People are asking whether it is for ...
3
votes
2answers
475 views
SQL Server 2008 R2 (x86) and the Access Engine
All,
I have set up the Access Database Engine for SQL Server 2008 R2 (Service Pack 1) on many machines running x64 Windows 7 without any problems running as 'Administrator' (and setting up SQL Server ...
1
vote
1answer
53 views
Visual j# asks for SQL 2005, but I already have SQL Server 2008 installed
I recently installed Visual Studio 2010 full pack (including SQL Server 2008).
After that, I installed Visual j# Express 2005 in order to work on a project.
The problem is: When I try to open a new ...
0
votes
2answers
291 views
Why Intellisense doesn't work in SQL Server Management Studio 2008 R2? [closed]
I have SQL Server Management Studio 2008 R2.
I have tried these:
Tools->Options->Query Execution->SQL Server->General, make sure “By default, open new queries in SQLCMD mode” is unchecked
Go to ...
0
votes
0answers
45 views
The SQL Server 2008 license [closed]
can anyone knows what means Sngl OPEN 1 License No Level in the product: Microsoft SQL Server Standard Edition 2008 R2 Sngl OPEN 1 License No Level
0
votes
0answers
28 views
Scripting the creation of Partitions on Measure Groups in BIDS
We have an Analysis Services project, on SQL Server 2008 R2, and need to add a number of Partitions to the cubes, to improve the performance.
While it is possible to create the partitions against the ...
0
votes
1answer
87 views
Troubleshooting inconsistent ODBC connectivity
I'm attempting to integrate UPS WorldShip with a SQL Server 2008 R2 database but the connection is very inconsistent. UPS claims this is a DSN/Windows problem and I have not been able to convince them ...
0
votes
1answer
25 views
Opening a database made in SQL Server 2008 Developer Edition in SQL Server 2008 Standard Edition
I have a database built in SQL Server 2008 Developer Edition but am unable to open it in SQL Server 2008 Standard Edition. It says the version of my SQL Server is too old.
How can I solve this ...
0
votes
1answer
236 views
SQL Server 2008 Management Studio - Edit Rows with Where clause
There is an option to edit rows in a grid - first 200 by default.
In Tools -> Options -> Sql Server Object Explorer, you can set the value for "Edit Top N rows".
I have a table with 200000 ...
0
votes
0answers
100 views
Entity Framework, ASP.NET MVC and performance
I have problem with performance and don't understand behaviour of EF. I use ASP.NET MVC application and have the following code in model:
public List<Portal> PortalListWithCategories()
...
0
votes
1answer
186 views
Installing SQL Server 2008 R2 Management Studio
My dev box is a Windows 7 machine and I am trying to install SQL Server 2008 R2 Management Studio.
When I run the installation SQLManagementStudio_x64_ENU.exe (downloaded from Microsoft site), it ...
5
votes
2answers
304 views
Encrypting my laptop hard drive
I've considered encrypting my laptop hard drive for a while now, but the only thing holding m back is my Microsoft SQL Server 2008 installation. I use my laptop for development and also have some ...
4
votes
3answers
154 views
How to use Microsoft SQL Server 2008 as a simple database for testing
As a student, I get Microsoft SQL Server 2008 R2 for free through MSDNAA. I installed it, but I seem to be at a loss for how to use it to test database queries, and how to construct a database with ...
3
votes
3answers
2k views
How to execute a stored SQL procedure in Microsoft Excel?
How can I execute a stored procedure in Microsoft Excel and get all the data it returns?
0
votes
1answer
396 views
How to change SQL Server 2008 authentication mode?
I have an SQL Server 2008 and I want to check/change its authentication mode. Now I've seen several ways to do so in the web using SQL Server Management but I don't have that..
Is there any way to do ...
1
vote
2answers
333 views
Can't access SQL Server from outside the network
I am trying to log in remotely to SQL Server 2008 R2. After reading several posts I was able to log in remotely from a computer on the same network. But I still cannot remotely log in from outside ...
1
vote
2answers
465 views
Change font in MS SQL Management Studio Database Diagram
My eyes must be getting old as viewing database diagrams is getting more difficult every year. Is there a way to change font type and/or increase the font size of text in database diagrams? I've ...
0
votes
1answer
166 views
Which SQL Server package is to be used for Mac?
I want to install the SQL Server 2008 in my Mac machine. I have used the one appropriate for my Windows machine. Now I want to install into the Mac, so please suggest the appropriate software package ...
0
votes
1answer
178 views
Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?
We're evaluating using SharePoint 2010 as our project management tool.
Specifically, the system needs to satisfy the following:
Discussion groups
Project management (simple issue tracking, no ...
2
votes
0answers
235 views
Database 28 cannot be autostarted during server shutdown or startup
I installed SQL Server 2008 on a PC with xxx.xxx.x.200. When I connected to the server from another machine(say xxx.xxx.x.81) using SQL Server Management Studio, I get the following error.
TITLE: ...
1
vote
0answers
65 views
How to configure Munin to montior Microsoft SQL Server 2008
Is it possible to configure Munin to montior Microsoft SQL Server 2008?
On Windows 2003 Server.
4
votes
3answers
218 views
Can I install Microsoft SQL Management Studio by itself?
I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008.
Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't ...
0
votes
1answer
155 views
SQL Server 2008 Enterprise Install - Missing Rockall.dll
I'm trying to install SQL Server 2008 Enterprise on Windows 7 Enterprise.
When I run setup.exe from the English/SQL2008/Enterprise folder, I get an error box titled pcaui.exe - System Error ...
0
votes
1answer
843 views
Viewing table relationships in SQL Server Management Studio
In SQL Server Management Studio, I have relationships set up between tables.
Is there a way to display a view of all the tables with the adjoining lines like in Microsoft Access? Do I need to open a ...
0
votes
1answer
346 views
Installing SQL Server Management Studio on Visual Studio 2010 Ultimate edition
FYI, I have BOTH Visual Studio 2010 Ultimate version AND express edition(Visual web developer) installed on my computer.
I open up Web Platform Installer and select "SQL Server 2008 R2 Management ...
0
votes
1answer
106 views
Windows update and SQL Server 2008 Service Pack 1
My o/s (vista ultimate 64) has been offering this up since it was published on 6/14. Three times I downloaded and installed it, along with the attendant restart!
Info from the SQL Server Mgt Studio ...
0
votes
1answer
560 views
IIS 7: How do I install Bugzilla?
I have Bugzilla 4 and I need to get it to run on a Windows Server 2008 running IIS 7. I've looked at various tutorials with no luck. Please direct me on how to setup Bugzilla!
3
votes
2answers
627 views
Change SQLEXPRESS instance name
I installed VS2010 and it automatically installed SQL Server 2008 Express.
Now, the installed instance is called SQLEXPRESS, therefore to connect to it I have to use 'localhost\SQLEXPRESS' or ...
1
vote
2answers
927 views
SQL Server Express Failed to Install
I am attempting to install SQL Server Express (as part of the Visual Studio 2010 Professional installation), but it is failing. I am receiving this error log.
[06/22/11,16:31:39] Microsoft Visual ...
0
votes
2answers
161 views
How to connect SQL Server across the Work Network?
SQL 2008:
I am trying to access SQL Database which is running on Server / Test Computer which has Windows XP OS.
My Computer and Test Computer both are connected in our Local Network.
Still I am ...
3
votes
3answers
629 views
How to remove a broken installation of SQL Server 2008?
After installing the Service Pack 2 of Microsoft SQL Server 2008, the SQL Server failed to start. Trying to repair this, I've done some stupid things, which results now in the situation in which I ...
