FAQ:Cannot create database - Revision history

Peder: /* I cannot connect to a database or database server */

2015-06-03T19:13:41Z

I cannot connect to a database or database server

Peder at 19:13, 3 June 2015

2015-06-03T19:13:23Z

Peder at 14:13, 28 May 2015

2015-05-28T14:13:33Z

Peder at 12:58, 28 May 2015

2015-05-28T12:58:07Z

Peder at 12:45, 28 May 2015

2015-05-28T12:45:40Z

Peder at 08:45, 28 May 2015

2015-05-28T08:45:04Z

Peder at 08:44, 28 May 2015

2015-05-28T08:44:50Z

Peder at 07:44, 28 May 2015

2015-05-28T07:44:21Z

Peder at 16:51, 27 May 2015

2015-05-27T16:51:35Z

Peder at 16:45, 27 May 2015

2015-05-27T16:45:36Z

@@ Line 3: / Line 3: @@
 <br>[[:FAQ | Back to FAQ list]]
 ====I cannot connect to a database or database server====
-<onlyinclude>Test only include</onlyinclude>
+[[FaqAnswer::A common cause of this kind of problem is that you do not have the permission to create a new database on the SQL Server instance. If an IT administrator has installed SQL Server / Express on your computer but not added your user account (in SQL Server Management Studio) with Write/Create privileges then you will not have permission to create new databases. If you are not even listed as a user with read privileges you will be able to connect to SQL Server instance at all.
 '''Solution 1:''' Request from your IT administrator to get "Create" privileges on the SQL Server instance you have problems with.
 '''Solution 2:''' If solution 1 is not possible you can run a light, file-based SQL Server version called LocalDB. If SQL Server 2012 / Express is installed and is running on your computer, LocalDB is already installed. Just enter "(LocalDB)\v11.0" as the name of the database server. By default, the database files will be placed directly under your profile (C:\Users\YourUserName). From Heureka version 2.3 you will also have the option to select "LocalDB" from the list of database servers, and also to install LocalDB if you have no SQL Server/Express (2012 or later) installed. LocalDB has the same database size limitations as SQL Server Express (10 GB per database).]]

@@ Line 1: / Line 1: @@
 [[Newsdate::2015-05-28]]  [[language::en| ]]
 [[Category:FAQ]]
+<br>[[:FAQ | Back to FAQ list]]
 ====I cannot connect to a database or database server====
 <onlyinclude>Test only include</onlyinclude>

@@ Line 3: / Line 3: @@
 ====I cannot connect to a database or database server====
+<onlyinclude>Test only include</onlyinclude>
 '''A:''' [[FaqAnswer::A common cause of this kind of problem is that you do not have the permission to create a new database on the SQL Server instance. If an IT administrator has installed SQL Server / Express on your computer but not added your user account (in SQL Server Management Studio) with Write/Create privileges then you will not have permission to create new databases. If you are not even listed as a user with read privileges you will be able to connect to SQL Server instance at all.
 '''Solution 1:''' Request from your IT administrator to get "Create" privileges on the SQL Server instance you have problems with.
 '''Solution 2:''' If solution 1 is not possible you can run a light, file-based SQL Server version called LocalDB. If SQL Server 2012 / Express is installed and is running on your computer, LocalDB is already installed. Just enter "(LocalDB)\v11.0" as the name of the database server. By default, the database files will be placed directly under your profile (C:\Users\YourUserName). From Heureka version 2.3 you will also have the option to select "LocalDB" from the list of database servers, and also to install LocalDB if you have no SQL Server/Express (2012 or later) installed. LocalDB has the same database size limitations as SQL Server Express (10 GB per database).]]

@@ Line 6: / Line 6: @@
 '''A:''' [[FaqAnswer::A common cause of this kind of problem is that you do not have the permission to create a new database on the SQL Server instance. If an IT administrator has installed SQL Server / Express on your computer but not added your user account (in SQL Server Management Studio) with Write/Create privileges then you will not have permission to create new databases. If you are not even listed as a user with read privileges you will be able to connect to SQL Server instance at all.
-Solution 1: Request from your IT administrator to get "Create" privileges on the SQL Server instance you have problems with.
+'''Solution 1:''' Request from your IT administrator to get "Create" privileges on the SQL Server instance you have problems with.
-Solution 2: If solution 1 is not possible you can run a light, file-based SQL Server version called LocalDB. If SQL Server 2012 / Express is installed and is running on your computer, LocalDB is already installed. Just enter "(LocalDB)\v11.0" as the name of the database server. By default, the database files will be placed directly under your profile (C:\Users\YourUserName). From Heureka version 2.3 you will also have the option to select "LocalDB" from the list of database servers, and also to install LocalDB if you have no SQL Server/Express (2012 or later) installed. LocalDB has the same database size limitations as SQL Server Express (10 GB per database).]]
+'''Solution 2:''' If solution 1 is not possible you can run a light, file-based SQL Server version called LocalDB. If SQL Server 2012 / Express is installed and is running on your computer, LocalDB is already installed. Just enter "(LocalDB)\v11.0" as the name of the database server. By default, the database files will be placed directly under your profile (C:\Users\YourUserName). From Heureka version 2.3 you will also have the option to select "LocalDB" from the list of database servers, and also to install LocalDB if you have no SQL Server/Express (2012 or later) installed. LocalDB has the same database size limitations as SQL Server Express (10 GB per database).]]

@@ Line 4: / Line 4: @@
 ====I cannot connect to a database or database server====
-'''A:''' [[FaqAnswer::A common cause of this kind of problem is that you do not have the permission to create a new database on the SQL Server instance]]. If an IT administrator has installed SQL Server / Express on your computer but not added your user account (in SQL Server Management Studio) with Write/Create privileges then you will not have permission to create new databases. If you are not even listed as a user with read privileges you will be able to connect to SQL Server instance at all.
+'''A:''' [[FaqAnswer::A common cause of this kind of problem is that you do not have the permission to create a new database on the SQL Server instance. If an IT administrator has installed SQL Server / Express on your computer but not added your user account (in SQL Server Management Studio) with Write/Create privileges then you will not have permission to create new databases. If you are not even listed as a user with read privileges you will be able to connect to SQL Server instance at all.
 Solution 1: Request from your IT administrator to get "Create" privileges on the SQL Server instance you have problems with.
-Solution 2: If solution 1 is not possible you can run a light, file-based SQL Server version called LocalDB. If SQL Server 2012 / Express is installed and is running on your computer, LocalDB is already installed. Just enter "(LocalDB)\v11.0" as the name of the database server. By default, the database files will be placed directly under your profile (C:\Users\YourUserName). From Heureka version 2.3 you will also have the option to select "LocalDB" from the list of database servers, and also to install LocalDB if you have no SQL Server/Express (2012 or later) installed. LocalDB has the same database size limitations as SQL Server Express (10 GB per database).
+Solution 2: If solution 1 is not possible you can run a light, file-based SQL Server version called LocalDB. If SQL Server 2012 / Express is installed and is running on your computer, LocalDB is already installed. Just enter "(LocalDB)\v11.0" as the name of the database server. By default, the database files will be placed directly under your profile (C:\Users\YourUserName). From Heureka version 2.3 you will also have the option to select "LocalDB" from the list of database servers, and also to install LocalDB if you have no SQL Server/Express (2012 or later) installed. LocalDB has the same database size limitations as SQL Server Express (10 GB per database).]]

← Older revision		Revision as of 07:44, 28 May 2015
Line 1:		Line 1:
−	[[Newsdate::2015-02-02]] [[language::en\| ]]	+	[[Newsdate::2015-05-28]] [[language::en\| ]]
	[[Category:FAQ]]		[[Category:FAQ]]

← Older revision		Revision as of 16:51, 27 May 2015
Line 1:		Line 1:
		+	[[Newsdate::2015-02-02]] [[language::en\| ]]
	[[Category:FAQ]]		[[Category:FAQ]]
−	~~[[Newsdate::2015-02-02]] [[language::sv\| ]]~~

	====I cannot connect to a database or database server====		====I cannot connect to a database or database server====