The sql-server-2008-express tag has no wiki summary.
0
votes
3answers
42 views
How to connect to ms sql express?
I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
1
vote
1answer
47 views
My php site cannot connect to SQL Database - SqlExpress2012
Im quite new to SQL Express 2012, but have just installed it on my server 2008 r2.
Im trying to install a CMS called joomla, which I' ve done many times before both on SQL community server and hosted ...
0
votes
0answers
154 views
Creating database from Entity Framework and Code First create database error
This got kicked off of Stackoverflow as off topic. I was told to post here so hoping you guys can help me out.
I'm running on MSSQL 2008 Express, EF5 and MVC4
My web.config file looks a bit like ...
0
votes
1answer
229 views
cannot connect to sql server express from sql server standard
... like my title says... I cannot connect to my instance on sql server express from sql server standard... I have tried disabling firing wall and checked sqlbrowser is started but for some reason I ...
0
votes
1answer
37 views
SQL server 2008 are prevented form being installed on Windows 7 - error message “access is denied ”
I have recently installed Windows 7 enterprise . When I try to Install Microsoft SQL server 2008 EXPRESS edition , I get an error message : "Access is denied" just right after the installation process ...
0
votes
0answers
303 views
Automate Sql Server 2008 R2 Express install - silently and pre-configured
I want to create a .MSI installation of my app. One of the things that should be installed it's the SQL Server 2008 R2 Express, but i want it to be installed silently, pre-configured for all client ...
1
vote
1answer
262 views
Why is SQL maxing out at 50% of CPU on my EC2 c1.medium instance?
I'm new to AWS, so I think this might be a really simple question:
I'm using an EC2 t1.micro instance as my SQL DB server for some small-scale analysis that I'm doing (Windows, SQL Express 2008). It ...
0
votes
1answer
40 views
SQL Express 2008 uninstall not complete
How do I get rid of SQL Express 2008 after it's been uninstalled. It's all over my file system and all over the registry on 2008 R2 server sp1.
1
vote
1answer
88 views
Unable to connect to remote MS SQL Server 2008 Express SP3 instance by name
I am trying to connect to a remote MS SQL Server 2008 SP3 x86 Instance using it's name.
At the first glance all seems to work well (e.g. it is possible to connect to the server locally and ...
1
vote
1answer
40 views
SQL Server Express Default Protocols Set On Installation
Are named pipes and TCP/IP disabled by default, when SQL Server Express 2008 is installed? I am trying to figure out if these two protocols being disabled was an act of installation or subsequent ...
-1
votes
1answer
32 views
MSSQL service fails to come up on vm restart
We have a MS SQL 2008 R2 express installation on a VM. If the entire VM node reboots then the SQL service fails to come up. Restarting the VM in isolation results in running service. We have put the ...
0
votes
1answer
209 views
Clarrification for SQL Server Express 2008 R2 on CPU limit (CPU based on core based)
I'm aware that SQL Server Express 2008 is having few limitations on the database size and the CPU utilization. In MSDN documentation it was mentioned on the express edition would use only one CPU.
I ...
0
votes
1answer
120 views
SQL express 08 R2 running on Windows datacenter server 08 optimization
I am running SQL server express R2 on Win Server Data Center 08 (basically Ec2 micro instance). My total allowed memory is 613 MB. When I launched the instance for the first time my total consumed ...
0
votes
2answers
67 views
Remote connections allowed, firewall off, SSMS still can't find SQL Express
My remote server running 08 R2 can connect to it's SQLExpress instance via SSMS. db Properties has 'Permit remote connections ticked'. Firewall off doesn't help. Another thread here shows 'sqlcmd -e ...
0
votes
3answers
237 views
Connect to remote SQL Server instance using Windows Authentication
How can I connect to a remote instance of SQL Server (on my VPS) from my local machine using Windows Authentication?
By default, if I try to connect using this method, the username is my computer ...
1
vote
1answer
237 views
Trouble installing SQL Server Management Studio Express
Using VirtualBox I am running 64 bit versions of ...
Windows Server 2008 R2
SQL Server 2008 R2 Express
SharePoint Foundation
I want to install SQL Server Management Studio Express, but I get this ...
0
votes
1answer
57 views
SqlServer doesn't allow other users to login from other computers
I have a server running MS SQL Server 2008 Express. Windows Authentication is used to authenticate the accounts to determine what they can and cannot access.
I have no problems accessing the server ...
1
vote
2answers
45 views
SQL2008 and SQL2008r2Express on same server
I'm going to add a SQL2008r2Express instance to a Win2003 server where a SQL2008 instance already exists. The new (express) instance will have another name, of course. That is to use the 10GB free ...
3
votes
1answer
37 views
Can an Instance of SQL Server Express 2008 R2 be used as a Master Server?
For multi-server administration, can an instance of SQL Server Express 2008 R2 be used as a SQL Server Agent Master Server?
1
vote
2answers
276 views
SQL Server Express - Move by Copying Data Folder?
We are moving our SQL Server to new hardware. Initially we were going to do this simply via backup and restore, but noticed we'd have to recreate all the logins. We don't want to do that :)
...
0
votes
1answer
406 views
Sharepoint Foundation License Costs [duplicate]
Possible Duplicate:
Can you help me with my software licensing question?
This question keeps getting asked however I could never get a straight answer. So I'm asking it clearer:
If I have ...
0
votes
1answer
63 views
How to configure SSL on an instance of SQL Server to allow dedicated users to remotely access it?
I have configured the instance of SQL Server to allow dedicated users to access it remotely.
Connection string Data Source = 192.168.1.2,1433\sqlexpress;etc... has been tested and works.
However, I ...
0
votes
0answers
947 views
SQL Connection String to access localhost\SQLEXPRESS
I've installed SQL Express on my PC hoping to do some practice creating tables and then modifying them. I coded a webpage in Visual Studio to, basically, SELECT * from a table in the SQLEXPRESS, but I ...
0
votes
1answer
245 views
Infrastructure setup question about Exchange 2010 and SQL 2008
How would you set up this scenario concerning a network of 22 users?
I have 2 servers for actual hardware with raid and 12gb and 16gb of ram.
Both are Server 2008 R2 standard. Both servers are ...
0
votes
5answers
185 views
200 Sites using 200 SQL Express DBs or 1 SQL Standard?
Let's say you have an Amazon EC2 Server.
What should use less resources:
200 Websites....
each using an individual SQL Express DB (200 in total, 1 per site)
or all sites using 1 SQL Standard ...
0
votes
1answer
49 views
moving data from sql server express 2008 to mssqlserver version 2000
I know I'm going the wrong way but is there a way to move a database from a SQLEXPRESS 2008 server to an MSSQLServer version 2000?
0
votes
2answers
285 views
SQL Server 2008R2 Express: which is the users limit in a real case scenario?
I know that sql server express has not a user limit, and every application has a different way to load/stress the server.
But let's take "a typical accounting software", where users input some ...
0
votes
2answers
457 views
SQL 2008 R2 express: Server Cannot open database requested in login 'xx'. Login fails. Login failed for user 'NT AUTHORITY\SYSTEM'
I have SQL Server 2000 installed on the server. I installed SQL Server 2008 R2 express edition as required for new application. The application runs on the same server which is Windows Server 2003 ...
0
votes
1answer
313 views
Search Server 2010 Express with full SQL Server 2008
By default, standalone installation mode of Search Server 2010 Express automatically installs SQL Server 2008 Express.
Is it possible to use standalone mode with full SQL Server 2008, not Express? Or ...
2
votes
1answer
459 views
Installing MS SQL Server 2008 R2 side by side with MS SQL 2008 R2 Express edition
I have to install full version of MS SQL 2008 R2 (it's Web edition) side by side with MS SQL 2008 Express (for a short period, before migrating all db's to full version).
I guess that it can be ...
1
vote
1answer
112 views
Is SQL 2008 Express R2 really free like 2005 Express is?
About to download it, keeps talking about "evaluation" and "evaluating SQL 2008 R2" and want to be sure it doesn't expire after 60 days or something.
2
votes
3answers
906 views
SQL Server 2005 Express: date of mdf file doesn't change, ldf file get huge
Sorry if the question has been answered or is asked in a wrong way - I am developer, no sys- or database admin.
Problem:
An SQL Server 2005 Express mdf file (size 370 MB) didn't change it's file date ...
1
vote
1answer
326 views
Migrate database from SQL Server Standard to SQL Server Express for DotNetNuke
we have an old server that we want to dedicate fully as a public webserver (hosting a few DotNetNuke sites), and for this purpose we would like to install SQL Server Express (probably 2008) on the ...
0
votes
1answer
290 views
Installing SQL server service, account to use
I'm in the following situation(With SQL 2008 Express):
It says "Microsoft recommends that you use a separate account for each SQL Server service."
Okay. This is my local machine I'll be developing ...
1
vote
4answers
549 views
Cannot get SQL Server 2008 Express R2 to get through firewall
Try as I might I cannot get remote access to my install of SQL Server. I know the firewall (Windows Server 2008) is the problem, since if I drop the firewall I can connect fine. I have the port open ...
1
vote
1answer
47 views
Any gotchas to installing SQL Express 2008 after SQL Server 2008 on same machine?
Are there any particular issues to watch out for? This is for my development machine so I will be debugging against both SQL Express 2008 and SQL Server 2008. Is the same SSMS used to connect to ...
0
votes
1answer
5k views
Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error
It looks like it's possible for 2008 SP1: previous question.
But what about current newer 2008 R2 version?
We plan to use single 32bit Express edition package to install on every machine. However, ...
1
vote
2answers
795 views
Sql Server 2005 Replication to Sql Server 2008 R2 Express
Is it possible for a Sql Server 2008 R2 Express instance to subscribe to a publication on Sql Server 2005? This is for Merge Replication.
Update:
Please note the Publisher is Sql 2005 and the ...
0
votes
2answers
284 views
SQL Server 2008 Express, need to copy a table from one server to another automatically
We have 2 servers with SQL Server 2008 Express for IVR systems and one for our website. The website's database server is more accessible on our network. I would like to copy some tables from the other ...
0
votes
2answers
424 views
Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine
At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not.
I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
0
votes
4answers
126 views
Using SQL Express creatively
The company I work for has an old sql server based legacy system, it's been around for about 7 years old with a 13gb database. There are two servers, web + sql. If we were to partition the database on ...
0
votes
1answer
199 views
Does SQL Server Express 2008 R2 eliminate the need to install MS SQL Server 2008 Express then SP1?
To install SQL Server 2008 plus SP1 on Win 7 machines, you have the following options:
1) install the deployment (runtime only - no management tools) version with SP1 built in
2) install the pre-SP1 ...
-3
votes
1answer
1k views
SQL Server 2008 R2 Express accepts only local connections? [closed]
Coming from question SQL Server 2008 connection tagged under sql-server-2008-express
Chris S wrote in SQL Server 2008 R2 vs. SQL Server 2008 R2 Express:
"The biggest different I see others ...
1
vote
4answers
1k views
SQL Server 2008 connection
I'm trying to connect to my SQL Server on my VPS but i can't get this to work.
I have enabled the TCP/IP protocol on SQL.
I also have the SQL Server and SQL Browser service running as a network ...
2
votes
4answers
2k views
SQL Server 2008 R2 vs. SQL Server 2008 R2 Express
What differences exist between the pay and free version of MSSQL2008R2?
Microsoft SQL Server 2008 R2
http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx
and Microsoft SQL Server 2008 R2 Express
...
1
vote
1answer
183 views
SQL SERVER 2008 R2 INSTANCESHAREWOWDIR Issue
I am trying to install SQL SERVER R2 Express Advanced Services on my VServer (Windows 2008 SP2 64bit). The server has also a sql server 2005 express instance for plesk...
I am running in the strange ...
0
votes
1answer
397 views
SQL service log on account
I installed SQLServer 2008 Express and pretty much took all the defaults. After about a week of running an app that hits this database I changed the administrator password for the server. About a day ...
1
vote
1answer
596 views
How to create a new database schema in SQL Express and give access to any user account of the current machine?
Mixed Mode / SQL Authentication is disabled.
Only Windows Authentication is available.
A database/schema has been created in the default instance (.\SQLEXPRESS) and is named "MyDatabase".
Using a ...
0
votes
1answer
113 views
Order of installation? SQL Server 2008 + SP2 + New instance of SQL Server 2008
I installed a SQL Server 2008 Express instance. Then I installed SQL Server 2008 SP1. Now I want to install a second, seperate instance of 2008 Express.
After I install, do I need to re-run the ...
0
votes
2answers
1k views
This database is not enabled for publication
USE GlobalSales;
GO
EXEC sp_helpmergepublication GlobalSales
EXEC sp_helppublication GlobalSales
EXEC sp_helppublication_snapshot GlobalSales
GO
-- Execute this batch at the Publisher.
DECLARE ...
