Should My Site And Sql Be On The Same Server
Apr 11, 2007
Hello,
I am upgrading my site from a VPS with a shared SQL server to a dedicated server and my own sql server 2003 standard. My site is an ecommerce site with about 10,000 users a month with between 10-20 people on the site at one time.
It is better to host both my site and the SQL server on the same system or is it better to have them on separate systems? if they are on the same system is 1 gig of ram enough? is will there really be much better performance with 2 gigs?
Any information on the best way to do this would be greatly appreciated!!!
Best regards,
~ Moe
View 2 Replies
ADVERTISEMENT
Oct 2, 2000
Hi,
can anyone tell me how exactly sql server7 interacts with Site Server, LDAP.
I am a sql dba, trying to work with above ones. Anyone pls suggest me any book or material or ur ideas.
Thanks!
--Siva
View 1 Replies
View Related
Apr 30, 2004
hi all,
could anybody send me the tutorial site for learning sql server...
especially in stored procedure,functions,triggers.
thanx in advance
View 2 Replies
View Related
Jun 1, 2007
How to create DTD compatible XML file from result set returned from a query.
Can we access FTP site and upload this xml ?
Is it possible to do from Tsql?
View 2 Replies
View Related
Apr 10, 2006
Can someone show me, or direct me, to a source, that shows me how, and what to change, when deploying a website from a development server running Sql Ex to a production server running Sql server 2005. I can’t get the sites to run under Sql server 2005.
They work in Sql Ex. what must I change? The connection string, to what format? and what else? I attached the dB to Sql 2005 and browsed the content in the Sql manager. But can’t get the aspx pages to work on the server.
Help please
View 6 Replies
View Related
Jan 15, 2007
Would it be recommended to use SQL Server 2005 Compact Edition on a web site, if that site received very few requests per month?
View 1 Replies
View Related
Feb 11, 2006
Hello everybody!
Can anyone tell me what steps i should follow in order to get my web site (which is hosted with a web host in ireland) to connect to yet another server (different country) where SQL Server 2005 will be running?
Thank you! - Callam
View 1 Replies
View Related
Apr 14, 2008
HI...I wonder if anybody could assist my problem. I am very new to online. I have bought a DIY portal and hosting. It is on SQL server.
I wanted to do a lead capture page and put an Autoresponder to it. I bought AD 2019 and Porfit Sponder, but it's requirement is UNIX operating system.
1. Can I link the AR(needs UNIX) to my site on SQL ?
2. Does it need a device to translate any data ?
Regards,
Lena
Money is in the lists...where did my money go?
http://simurl.com/more-E-GOLD
http://simurl.com/Top3Percent
View 4 Replies
View Related
Jan 9, 2007
I'm currently learning my way around with SQL Server 2005 and asp.net 2.0, and for this I wrote a little site that uses SQL Server for it's backend.
I developed it on my laptop, and it works great, until I deployed the website to my test server, so it's visible to the outside world.
The instance I try to access any page that invokes the database, I get the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).
The server doesn't differ much from my laptop setup, except that it accepts connections through named pipes and TCP/IP and has the Network Service as a user(I also tried running the website under Administrator privileges, just to test it out).
Both IIS and the SQL Server running on the same machine(Windows 2003 Server SP1), and the SQL server accepts connections from a locally running SQL Management Studio Express instance. However: It does not accept connections from my laptop, which resides outside the domain. The server is set to use Windows Authentication for log ins.
What am I doing wrong here?
EDIT: Filled out this found questionare:
[1] Client side:
What is the connection string in you app or DSN? (please specify) connectionString="Data Source=.SQLEXPRESS;Initial Catalog=EroSite;Integrated Security=True" providerName="System.Data.SqlClient"
If client fails to connect, what is the client error messages? Error Locating Server/Instance Specified
Is the client remote or local to the SQL server machine? LocalCan you ping your server? YesCan you telnet to your SQL Server? YesWhat
is your client database provider? ADO.NET2.0
Or/And, what is your client
application? Website using DataSets (Works fine with Server Management Studio)
Is your client computer in the same domain as the Server computer? Local machine
What protocol the client enabled? Shared Memory, TCPIP, Named Pipes.Do
you have aliases configured that match the server name portion of your
connection string? NoDo you select force encryption on server and/or client? No
[2] Server side:
What is the MS SQL version? SQL Server 2005What is the SKU of MS SQL? ExpressWhat
is the SQL Server Protocol enabled? Shared Memory | TCPIP | Named
Pipes
Does the server start successfully? YesIf SQL Server is a named instance, is the SQL browser enabled? YesWhat is the account that the SQL Server is running under? Local SystemDo
you make firewall exception for your SQL server TCP port if you want
connect remotely through TCP provider? not applicableDo
you make firewall exception for SQL Browser UDP port 1434? In SQL2000,
you still need to make firewall exception for UDP port 1434 in order to
support named instance. Not applicable
[3] Platform:
What is the OS version? Windows 2003 SP 1Do you have third party antivirus, anti-spareware software installed? No
View 7 Replies
View Related
Nov 10, 2005
Hi there.I have made a site with some *.mdf database files that works fine at home. I use Sqlexpress, but when i copy my files to the host server (ASP 2.0 SQL server 2005) the *.mdf file will not attach.I get the following error : CREATE DATABASE permission denied in database 'master'.Could not attach file 'D:Websites***********.netApp_DataDatabase.mdf' as database 'Database'.I have tried with a lot of different connection strings but no one work.My current connection stirng is: <add name="ConnectionString_Default" connectionString="Data Source=>>IP Number<<;Initial Catalog=Database;AttachDbFilename=D:Websites>>my path<<.netApp_DataDatabase.mdf;Integrated Security=True;" providerName="System.Data.SqlClient"/>Is there any problem just copying my files to the host server, and then correct the connection string. Is Sql Server 2005 able to attach a *.mdf file just as SQLexpress is.Please help me soneone . Time is running, and I am late with my project.p.s. I am the first using the host server setup with sqlserver 2005. There may be something wrong with theri setup.Thans RHJ
View 3 Replies
View Related
Jan 9, 2006
Lets say I use the 'enabling roles' for my ASP 2.0 site. This creates a ASPNETDB.DBF SQL Express file.
Later I go to post this to a real web server - which runs the 'full' MS SQL2005 server. What happens to the ASPNETDB.MDF file (or for that matter, any other MDF file I create with SQL Express) when it leaves the Express world and enters the Real world.
View 4 Replies
View Related
Oct 6, 2015
deploying a 2 node SQL AAG, with one VM each DC, in sync mode, in an active-active DC layout, with 1ms RTT and 1Gbps? Similar to a SAN based geo-cluster. HA and DR in a single tin.I'm trying to minimise license costs. Having the 2 node in DC1, with async to site 2 is double the license cost!!
View 5 Replies
View Related
May 20, 2006
I have installed SQL Server 2005 Express Advanced Edition. I wan to use it as a database backend for a Web Site I am building which will use the Snitz Forums ASP web. How do I se this up to work with the Snitz product? Yes I am new to databases and have never set up one for use in a web application or site before. I am grateful for any assistance or tutorials which can be given to help me accomplish this task.
View 9 Replies
View Related
Nov 14, 2007
I moved all my databases to sql server 2005 & when appliction is trying to connect to 2005 databases i get the following error
In the connection string i am using
Password=test;Persist Security Info=True;User ID=test;Initial Catalog=test;Data Source=externalip/instancename
this is the only change on the web server
Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
please let me know the problem
View 7 Replies
View Related
Mar 5, 2006
I have installed sql server express 2005 and also visual studio express developer when i run the personal web site sample I get the folowing error
Shared Memory Provider, error: 40 - Could not open a connection to SQL Server
How do I correct this please does any one know ?
View 4 Replies
View Related
Jul 23, 2007
I am trying to add a SQL Server 2005 Express Edition Database to my Web Site. But I am unablr to do so.
I am getting the following error: {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"}
I am unable to understand what exactly is the problem.
Pls Help me out.
Thanx In Advance.
View 2 Replies
View Related
Feb 18, 2008
Hi,
I keep getting a connection failed error message... CANNOT the DATABASE " " requested by the Login. The Login failed for User 'NT Authority/ Network Service' error and I figure I should create an account for the site to access the Database with but I do not know how to create an account in SQL server using the Management studio?? Anyone willing to give me the exact information I need to do this so I do not do something else and ruin things please??? I am not much of an SQL DBA. thanks in Advance.
View 10 Replies
View Related
Feb 28, 2008
Hi,
I want to implement site search in my application, I got the solution of searching the static content, but most of the pages in my application is content based(content is coming from database at runtime), so those content I am not able to search from database.
While searching about the same, I got information about Full Text search (FT) in SQL Server 2005, but whether it will work in SQL Server 2005 Express or not?
I didnt get exact steps to implement FT on my database so far....
Any help?
View 1 Replies
View Related
Mar 31, 2006
I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express. I ran the aspnet_regsql and it created the aspnetdb database. But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work. I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail. My SQL Server is installed on the Default Instance. Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?
View 1 Replies
View Related
Aug 16, 2000
Hi All,
I have an issue where I am told that we should run Exchange/IIS/MS SQL7/Site Server on same physical PC (cost cutting analysis).
Could anyone please tell me in a few words why I should not run the above mentioned services on the same physical computer ?
I would appreciate any input.
Regards,
Romy Stevensen
View 4 Replies
View Related
Jan 15, 2008
On my VWD 2005 Express, I have installed 2 SQL Server 2005 Express databases in the App_Data folder.I kind of remember these 2 databases were installed from Wrox web site or a zip file. Now we still useSQL Server 2000 databases for our ASP.net applications. I have downloaded the SQL Server 2005 Express.These 2 databases in the App_Data folder seem to work fine although I can not see them from theManagement Studio Express.
My question is: How do I 'manually' create a new SQL Server 2005 database into the App_Data folder?
TIA,Jeffrey
View 2 Replies
View Related
Nov 13, 2007
My site crashed, so I had to rebuild the Project Site.
I used the SharePoint products and technologies configuration wizard to disconnect from the server farm (only actually running on the single server).
I then reran SharePoint products and technologies configuration wizard to setup the site.
Configured the Project Service and attached to the existing dB's.
Previously, I used the url http://servername.domain.forest/PWA/default.aspx .
Now when I attempt the use the same URL, I get the following error:
"An unexpected error has occurred"
I have tested this one 3 servers now and I receive the exact same result. Is there a path I should apply to the servers in order to allow fully qualified server names after a reinstall of the system?
View 1 Replies
View Related
Sep 9, 2006
Hi,
Sorry for the wide distribution.
I'm trying to find any useful whitepapers about how to effectively build and operate a disaster recovery site at a remote location for SQL Server 2000. Does anyone know where to find such information?
I also know that one good option for my customer is using the Mirroring feature of SQL Server 2005. What are the other options? Is Replication an effective one for a mission-critical database (online banking)?
Thanks in advance
View 3 Replies
View Related
Feb 9, 2007
I have set up a locahost site in IIS using the "Configure Web Synchronization Wizard". One of the first test I was asked to do was to open a broweser and browse to http://localhost/MobileTest/sqlcesa30.dll
If all is well I should get a web page with the following line:
SQL Server Mobile Server Agent 3.0
But unfortunately I get an error stating :
"The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance."
I checekd the Event log and found this error related the IIS launch process on my machine.
DCOM got error "Logon failure: unknown user name or bad password. " and was unable to logon .IWAM_Rataq in order to run the server:
where Rataq is the name of my machine. Could my IWAM_Rataq account be corrupted, my other sites on the machine work.
Infact if i put in a Test.htm page in the virtual directory MobileTest I am able to browse to the page.
Can the Account be re-set? is there another problem that I am not aware of. I have Norton Internet 2006 running could that be the reason? Could Norton be blocking the dll from loading? But the event log states it is a Account error.
Any ideas why this might occur? any help is always appreciated
View 1 Replies
View Related
May 9, 2008
I recently installed SQL Server 2005 Enterprise on a machine running Server 2003. I have successfully configured Reporting Services (see below for summary of settings)
- Used the defaults for the Repor tServer and Report Manager Virtual Directories
- Windows Service Identity set to domain user. The domain user is part of the administrator group on the machine and has sysadmin rights to the database
- Web Service Identity set to NT AuthorityNetworkService
When I open http://localhost/reports/, I get the following error:
I have check a bunch of forums, but have no success. Any advise would be greatly appreciated!!
Server Error in '/Reports' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3a890e9c0 068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl34a099978 068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3de5a2332 0958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3498aee86 042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3cd47089b 0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3f180608d 0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl323449648 068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 5 Replies
View Related
Jul 24, 2007
would you use sql server "full text search" feature as your site index? from some reason i can't make index server my site search catalog, and i wonder if the full text is the solution. i think that i wll have to you create new table called some thing like "site text" and i will need to write every text twice- one the the table (let's say "articles table") and one to the text. other wise- there is problems finding the right urlof the text, searching different tables with different columns name and so on...
so i thought create site search table, with the columns:
id, text, url
and to write every thing to this table.
but some how ot look the wrong way, that every forum post, every article, album picture or joke will insert twice to the sqr server...
what do you think?
View 1 Replies
View Related
Oct 4, 2006
Dear All:
My reporting manager and reporting server were working fine in IIS. But when I booted the system one day, one error message came "Unexpected error" for the IIS. So I removed the IIS and reinstalled he same.
But after that, I tried to give virtual directories to reporting manager and reporting server sites. But it ain't working. Could you please help me?
My IIS 5.1
Reporting service 2005 Express with SQL Server Express
ASP.NET 2.0 Express.
Please help.
Thanks in Advance
Emmanuel Mathew
View 5 Replies
View Related
Jan 31, 2007
I have a website with membership system. I've been through a lot implementing the site and I think I'm on the verge of full implementation. I can't get my registration page or my admin page to add, edit or delete users. I'm assuming that asp does not have proper permissions on SQL to do such.
I'm running the site on a provider that has a SQL 2000 server. I access the database through VS2005 and SQL Server Management Studio Express.
Is there a tutorial out there that could help a newbie to SQL understand how to check and correct my permissions issue (or find out that I'm haveing a different issue entirely.
-Bill
View 3 Replies
View Related
May 26, 2008
Hi all,
I`m a .NET desktop-app developer and i`m new to ASP.NET and web development, i start developping a web application with SQL Server database and i want to know if i can put all my tables in ASPNETDB?
is any restriction with that?
Regards
View 3 Replies
View Related
Feb 3, 1999
Hello,
This may be the wrong place to add this but....
I am attempting to setup a membership instance for Site Server 3.0 using SQL 7 and try as I might, Site Server Membership will not see the server at all. I can do anything else I want to to that server and it works great (commerce, etc.). It all works OK under SQL 6.5 SP3 or later, just not SQL 7.
Does anyone have any thoughts or insights?
Thanks
John
View 1 Replies
View Related
Oct 6, 2003
I have to download a file from a ftp site using either SQL/T-Sql or ActiveX script. I'm using SQL Server 2000. Please help
Thanks in advance
View 2 Replies
View Related
Oct 13, 2004
Is there a good back up software that willl back up by SQL server to a FTP site. All of them I have seen either backs up to a disk or tape.
Thanks
Jay
View 2 Replies
View Related
Nov 17, 2004
Poeple are calling me for resume 5 years old. They need DBA's all over the country. Please pass it on to look at the job opportunities on this site.
View 2 Replies
View Related
