Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
russler01
Starting Member
5 Posts |
 Posted - 2006-10-09 : 22:24:27
|
| I am having the worst time getting connect to my database.. I just get error. But I have read somewhere (microsoft) that SQL Express can't have over 1gb of ram. My pc has 2gb will this stop me for building the sites and connecting to it? Do I need to upgrade my PC and the webserver to sql workgroup for me to be able to work on this.2 question. Can I just upgrade the server and connet to the server from my pc to build the basic pages in Dreamweaver in the web.config file as long as my PC is online? This way I don't have to buy it for my PC as well. If this is possible what would be a connection string i would use in the web.config file to make this work.Thanks you |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-10 : 01:27:35
|
ok, you need to tell us exactly what the problem is.- SQL express can use a maximum of 1GB of your 2GB RAM. If you have more memory it will not cause any problems, you just won't be able to use it with SQL express.
- I can't understand what you are asking in question 2
SQL Express disables network connection protocols by default on install. This means that you will not be able to connect to the instance from a remote host. You will only be able to connect to the database from the local system it was installed on.You can change that by using the SQL Server Configuration Manager. This information is also included in the readme file included with the installation of SQL Express.-ec |
 |
|
|
russler01
Starting Member
5 Posts |
Posted - 2006-10-10 : 09:50:37
|
| This is what I was trying to do but can't get it to work.I have sql express installed on my local machine and my online server. I use dreamweaver to do most of my work (very fast and easy). I am trying to get my web.config file to connect to the SQL server but everything I have tried I get a error. I have seen online about 100 different ways to write a connection and none of them seem to work for me. The two errors I have recieved from trying this is "connection faild" The other one is "[DBNETLIB][Connectionopen(Connect()).]SQL Server does not exist or access denied" I have found a lot of information on people getting this to work but no one posts it they just say its working now thanks.. LOLThis is what I have in my config right now but no luck yet.<add key="MM_CONNECTION_HANDLER_testdatabase" value="sqlserver.htm" /> <add key="MM_CONNECTION_STRING_testdatabase" value="Provider=SQLNCLI;Server=DELL-RLVMUKA5IY\SQLExpress;AttachDbFilename=c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\xusa.mdf;Database=dbname;Trusted_Connection=Yes" /> <add key="MM_CONNECTION_DATABASETYPE_testdatabase" value="SQLServer" /> <add key="MM_CONNECTION_SCHEMA_testdatabase" value="" /> <add key="MM_CONNECTION_CATALOG_testdatabase" value="" />Once I get it on my local server I can get it to work on the online server with changing a few things. Fi anyone could write this to work with Dreamweaver and web.config that would be great.Thanks so much for your help |
|
|
|
|
|
|
SQL Express Connection Problems