How to set up an SQL Server
-
Hi, folks! I've got a major question. How do I set up an SQL Server on my computer if I have 2 things: 1) Installed MS SQL Server 2005 2) an Access DataBase, which I want to port into a SQL Server, so other users/developers could connect to it, log in and perform their actions. I know, that this is a repeated question, and there have been such messages before. Therefore, any links or info will be appreciated. Thanks
-
Hi, folks! I've got a major question. How do I set up an SQL Server on my computer if I have 2 things: 1) Installed MS SQL Server 2005 2) an Access DataBase, which I want to port into a SQL Server, so other users/developers could connect to it, log in and perform their actions. I know, that this is a repeated question, and there have been such messages before. Therefore, any links or info will be appreciated. Thanks
Don't quite follow you. If you already have a SQL Server instance you can use, start with How to Migrate from Access to SQL Server 2000[^] (this applies to 2005 also). If you don't have the instance or want to add another to your machine, run setup for SQL Server Mika
-
Don't quite follow you. If you already have a SQL Server instance you can use, start with How to Migrate from Access to SQL Server 2000[^] (this applies to 2005 also). If you don't have the instance or want to add another to your machine, run setup for SQL Server Mika
Sorry for being confusing. I'm doing my best, but these are my first efforts in SQL Server and stuff I have installed an SQL Server (at least I think, that I did, bc I have checked it during the Visual Studio installation process). Then, I have installed a MS SQL Management Studio Express. You are right: I need to migrate from Access to SQL Server. But on the other hand, I can't find the interface in the Management Studio to allow me to create my own database. Maybe, that is because I use Express edition? Management Studio tells me that I'm not connected to the server, but I don;t want to connect at the first place, I need to set the server, so other people can connect to me and use my database.
-
Sorry for being confusing. I'm doing my best, but these are my first efforts in SQL Server and stuff I have installed an SQL Server (at least I think, that I did, bc I have checked it during the Visual Studio installation process). Then, I have installed a MS SQL Management Studio Express. You are right: I need to migrate from Access to SQL Server. But on the other hand, I can't find the interface in the Management Studio to allow me to create my own database. Maybe, that is because I use Express edition? Management Studio tells me that I'm not connected to the server, but I don;t want to connect at the first place, I need to set the server, so other people can connect to me and use my database.
No problem at all :) If I remember correctly, you don't have the option for installing SQL Server Express in Visual Studio, only Compact edition (single-user instance). So briefly the steps you should take: - download SQL Server 2008 Express Edition with Management tools - install it by running setup. This will install you a single instance - configure the instance using Management Studio - create a database that you will use for application - migrate your data from Access You can check if you have a SQL Server instance installed for example by looking at services in Control Panel. If SQL Server is installed, you will have a service called SQL Server (Instance name) Mika
-
Hi, folks! I've got a major question. How do I set up an SQL Server on my computer if I have 2 things: 1) Installed MS SQL Server 2005 2) an Access DataBase, which I want to port into a SQL Server, so other users/developers could connect to it, log in and perform their actions. I know, that this is a repeated question, and there have been such messages before. Therefore, any links or info will be appreciated. Thanks
-
No problem at all :) If I remember correctly, you don't have the option for installing SQL Server Express in Visual Studio, only Compact edition (single-user instance). So briefly the steps you should take: - download SQL Server 2008 Express Edition with Management tools - install it by running setup. This will install you a single instance - configure the instance using Management Studio - create a database that you will use for application - migrate your data from Access You can check if you have a SQL Server instance installed for example by looking at services in Control Panel. If SQL Server is installed, you will have a service called SQL Server (Instance name) Mika
I've spent half of the day trying to install SQL Server 2008, but it wouldn't install. At the very end it shows me a table saying that "Database Engine Services Failed", and "Replication Failed"
-
You might want to have a look at this http://www.codeproject.com/script/Forums/View.aspx?fid=1725&select=2681821&fr=616#xx2681821xx[^]
hi, It's giving warning that The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online. My Ram is 256MB.IT's need 512MB.so what should i do. IF you have any website where i can load sql server 2002. Thanks