Using SQL Server To Run Social Networking Website

Mar 17, 2008

I am currently using SQL Server 2005 Express to run a social networking website on a dedicated server (Windows Server 2003, code is written in ASP.net). Obviously express is too limited to run this site, but for now I am still getting the site operational so the demands are low. Soon I will begin advertising and adding many users to the site - can anyone recommend a version of SQL Server that I would need? My programmers say I should go with enterprise, but that seems overkill (and my hosting provider - theplanet.com does not even offer it). Would workgroup be enough, or should I go with standard edition?

To be honest I do not trust my programmers experience with SQL server which is why I am asking for help here (they are outsourced from India, and I am becoming more and more convinced that I need an onshore IT manager for them - finding that is another issue...). Also, are there built in backup features with SQL Server? My programmers told me recently that they will need to put in significant work to setup a backup system, but it seems to me like one might already be built in.

Thanks for your help,
Greg

View 6 Replies


ADVERTISEMENT

Networking SQL Server

Aug 10, 2007

Hi all,

We have a small office network consisting of 6 workstations and a server. I want to know if it is possible to be able to run sql server from the workstations and host the created sql databases on the server rather than an individual pc? If so how do i do this?

Thanks

View 2 Replies View Related

Networking With Personal Edition Sql Server 2000

Apr 26, 2002

I am using the personal edition of sql server 2000 and i have a number of databases stored on the harddrive, how would i set up a connection with other PC's to be able to view/modify/delete the data through an access 2000 front end. The other PC's will not have SQL server on them but will have Access 2000, they will need to go via the network which is non-microsoft compliant.

Thank you very much for you help it would be very much appreciated.

Britta

View 1 Replies View Related

How To Manage Sql Server Transaction In Desktop Networking Application Vb.net2005?

Jun 10, 2006

hi





i want to know that how to manage the sql server transaction in a

big desktop networking application?





for example





there are 200 tables in

database. many of that tables have relatationship. i have a form in

frontend which holds nere ablut 50 tables deffrent calculated amount. i

want to ADD, EDIT and DELETE, SAVE(commit), CANCEL(roll back) them and

same time another use will do the same work from another pc. if there

are 100 user does the same work (add, edit, delete, save, cancel) how

could i magage my sql server data???





i also want to know that





1 kind of

proffessionsl way to use sql server and vb.net?

2 what kind of septs to

develop a desktop networking application with sql server?

3 how i could

manage the transaction in sql server when there are many-many user

working in the same database(add, edit, delete, save-commit,

cancel-rollback).<img src="images/emoticons/smile_baringteeth.gif">

View 1 Replies View Related

Social Network Database Design

Jul 31, 2004

Hi,
I want a few tips on how to go about designing a schema for multi parent hierarchical tree structure.

Will this work in large scale, like Social Networking
how do we generally go about designing for Social Networks?
What could be the optimal architecture?

aravind

View 2 Replies View Related

Secure Social Security Number In My DataBase

Jun 13, 2006

Hi, i have a data base in SQL 2005 and i it has many tables with confidencial information Like Social Security numbers, Credit card Numbers, etc. And i would like to encrypt this information or make something to make this info invisible to any hacker, or any person that logs on the server.

Here are the limitations:

1 - I cant make any changes in the front end, so if i encrypt the data, I have to make all the modifications in the database, and if the front end needs some encrypted information, the database should dencrypt it.

Any one has any idea ???



Best Regards.

View 7 Replies View Related

Networking An Application...

Apr 5, 2008

I've written a program for one of my clients, and they are making alot of changes. Typically when I make a change, I have to go into the office and re-install the updates to every system that uses the application. I would like ot be able to install the application in a central location, and then run shortcuts to everyones PC so when I update the application I just have to install it in one place. How can I do this? Also they clients are running a windows domain in the office. How can I accomplish this task?

View 7 Replies View Related

Sql Client Networking Alias Dissapears

May 21, 2004

I have a network of all win2000 machines. The server is win2000 and is a domain controller running sql 2000. I've been having intermittent problems with our software staying connected to sql and found that installing the sql client networking package fixes it. The problem I'm having is that users with admin rights work just fine, but users with just user rights aren't. I set up client neworking by moving named pipes above tcp and setting the alias to the sql server but the user machines doesn't remember the alias.
Here's a list of what I've tried:

log in as admin and enter alias

create .reg file of proper registry settings and import but got a key is in use error, cannot import registry

created shortcut to cmd and set shortcut to run as diff user, log in as admin, run .reg file, imports fine, alias still missing in user computer.

Any ideas what might make the alias not stick? The users cannot install software and there might be some other security setting or restriction keeping it from sticking but I have yet to find it.

View 2 Replies View Related

Oracle Client And Networking Components

Apr 30, 2007

hi all.

In my SSIS project, i have to retrieve data from an oracle 10g database. On my personal laptop it works, but on our test-env i get the error below, when i try to test my connection to the oracle datasource.

Could this because i have oracle XE installed yet on my personal laptop, and it is not installed on the computer of our test environment where the SSIS runs? If that's the reason, it sounds very strange, because it would mean i have to install an oracle environment also on the computer with SSIS, just to make a connection to another oracle server...




Error:

TITLE: Connection Manager
------------------------------

Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.

------------------------------
BUTTONS:

OK
------------------------------

View 10 Replies View Related

Merge Replication (Pull Subscription) Synchronization With Out Networking

Aug 3, 2006

Hi I want to Set up Such Merge Replication, Which can can Synchronize With out Network, Means Syncronization using CD.

Also When the Network connectivity will be available then it should do synchronization

I wants to transfer some file using CD only those changes to database which hasn't been synchronized, thats why Backup will not work.

Pls Help me, or tell me wether it is possible or not.

Tell me some work around, or ask me details,

You got to help me out, Otherwise I will loss trust in MSDN Forums.

Thanks in advance
Vishalgiri Goswami

View 3 Replies View Related

The SQL Server Is Not On The Same Machine As The Asp Website

Jun 1, 2007

Hi, I'm new in asp.net and I have few questions.
My hoster have the SQL server and the webserver on different machine. I need to use a login  to restrict acces to some  webpages and I see that asp.net is storing that data in App_data/ASPNETDB.MDF which have the connection string set to local server. Can asp store that data on a remote database?
 

View 2 Replies View Related

SQL Server ---- Deploying A WebSite

Jun 25, 2007

Since from using my local host to view my website, I am assuming I already have SQL Server installed on my computer? Is it possible to have users access my website files directly onto there own computer, say if they type my ip address or domain name into their address bar?  What I am actually wanting to do is to host my website from my home computer... Any ideas, or good slash easy to understand articles on how to do this?

View 8 Replies View Related

How Do I Access The SQL Server From A Website.

Feb 2, 2004

How do I access the SQL server from a website, using my Machine Account, not the ASP.NET account?

thanks.

.intrino.

View 5 Replies View Related

Copying SQL Server Website To CD

Apr 10, 2005

Hi!
Not sure if this is the right place to post. I need to copy a website that I created on a CD. It is using SQL Server as the database and VB, ASP as front end. However, the problem is that I need to copy it in such a way so that it can be viewed from the CD itseld without needing MSDE or SQL Server. Need help.
Thanks.

View 3 Replies View Related

SQL Server As A Back End To A Website

Jun 15, 2006

Hi all
Hope you can help.
I've been using MS Access as a backend content server on websites for some time. However, I want to move to Sql Server but am struggling a bit with some of the concepts.

I want two types of users of the website.
1 User who can view data as a iusr_guest type user (no login)
2 can view/ edit data as a datawriter (website administrator).

With Access I would simply have a table or another db containing user info. If a user logged in and was accepted then a IIS user session would be created and they could edit the db.

Any views on how this type of simple db access should be managed using sql server?

best regards

chubster

View 4 Replies View Related

Secruity Question, Putting SQL Server 2000 Or 2005 On Windows Server 2003 Running A Website

Jan 31, 2006

Where can I further educate myself on this subject?

Right off from the start I would assume that installing SQL Server 2000 or 2005 on Windows Server 2003 that is set up as a web server hosting a website would be against "best practices." Is my assumption right?

Common sense tells me to not to host a website on a pc that is also hosting my database.

View 4 Replies View Related

SQL Server 2005 Express For A Website

Mar 26, 2007

Has anyone used SQL Server 2005 on a production website?  I know that it tops out at 1GB of ram, but it is free.  Any idea how much load it will take before you need to move up to the full version?

View 1 Replies View Related

Problem Of Uploading Asp.net Website On Web Server

Jul 16, 2007

i have developed a website using asp.net, c# with SQL SERVER EXPRESS EDITION 2005. The database is being used both for retreival and updation purpose.  the website is working accordingly when i m running it on my system, ie., data is getting retreived from the  database and it is also getting updated on button click. But when i m uloading my site on the httpdocs folder of web server, connectivity with database is failing miserably, ie neither getting retreived from the database nor getting updated.  The error message displayed by the web server is given underneath. i have used Grid view for displaying data from the database and Details view for updating the database.
i have used window authentication for connecting with the database.Please help me with finding out a solution for it. give me proper explanation and i need to do
Server Error in '/' Application.


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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

View 10 Replies View Related

Sql Server 2000 And Website Connection

Jan 22, 2004

What application/software can be used to conect a website to a sql server 200 backend.

Thanks!!

View 1 Replies View Related

Sql Server Certifcation Website Wanted

Jul 20, 2005

I am looking for sql server certifcation questions any one hasany.like dumps or some thing

View 1 Replies View Related

Timeout Exception On Sql Server Thru Website..

May 20, 2008



Hi,
I have a website where the user uploads DBF files and then i am calling a sproc to scrub the data and put them from the staging database to the production database. If the folder size small may be less that 6 it transfers the data from the staging database to the production.. But if the size of the folder is big.. more the 6 mb i get an timeout exception.. But i know the data is been put in few tables in the production databse..

for eg... if the size of the file is 33mb it takes around 15 mins or so for the sproc to process . I have tried setting the connect and commd timeout whcih has not helped.. I tried increasing the server.script time and it fails too..

this is the error in my event viewer


Error: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

No Changes made to the ClientPlan table.

Inserting records(s) in ClientPlan table.

No Changes made to ClientPlan table.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)

at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)

at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)

at icc.BaseClasses.DL.DLImportPlan.Import(Int32 ClientId, DateTime StartDate, DateTime EndDate, Int32 UserId) in C:Documents and SettingskroslundMy DocumentskareniccPlanStatementsiccImportDLDLImportPlan.cs:line 120

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


any help will be appreciated.

Regards
Karen

View 15 Replies View Related

Need Help On A Website Project (heavily Based On SQL Server)

Feb 26, 2007

Hi, I'm rather new here, but I would like to add the question here
since this project encompasses a lot of areas of ASP.NET (Visual Studio
2005).
My project is about a site which is heavily based on Search Option. So
basically, users will just have to fill in the forms, click search and
it will search throughout the database. For
example...
The website is about a property listing. The database (based on SQL
Server, can be created right through the Visual Studio 2005) consists
of these attributes: ID, Property Name, Property Location, Property
Cost. The user may search based on Name, Location and Cost. For the
cost, there are two forms to fill: the lowest cost allowed and the
highest cost allowed.All
these are put on the Master Page (Located on the top). When the button
Search is clicked, it will display the records that match the forms
filled, in the main page located below the Master Page.If anyone can help me with this, I'll be very grateful. Thank you very much. 

View 4 Replies View Related

SQL Server 2005 - Windows Application And Website

May 25, 2007

Hi there,
I have a question which I put the company that host my website but I didnt get a conclusive answer. Maybe someone here will be able to advise or help me with my situation.
I want to build a database that I will run on my local server and the front end of this will be run using a windows application. I have a website which I run the database on the remote server. What I would like to do is to be able to synchronize certain tables between the two databases (such as updating products table, or orders table). I am using sql server 2005 and I am using the sql server management studio to access my database on the remote server. I did notice there is a synchronzie button. I also came across some 3rd party tools. Not sure if that is the way to go.
If anyone as done this before or can give me any suggestions, I would be delighted.
Thanks
 Anthony

View 2 Replies View Related

Can I Use SQL Server 2005 Express In A Commercial Website?

Sep 19, 2007

Does anyone know if it is legal to use SQL Server 2005 Express in a commercial website?  There is no need for SQL Server 2005 so the Express would do the job great.Thx, Viktor 

View 2 Replies View Related

The Data On The Website Cannot Be Input In The Server Database..

Mar 6, 2008

hi there..
I have write a code in the submit button using vb code so that when people key in their email.. it will be saved in my created database called test.mdf. but when i debug it, i tried to write an my email address in the textbox in my website but when i click at the submit button, the web page display the email was not enter in my database.
here is the code, can anybody help me. i'm really lost here..
 Protected Sub SubmitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim TestDataSource As New SqlDataSource()TestDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("TestConnectionString1").ToString()
 
TestDataSource.InsertCommandType = SqlDataSourceCommandType.Text
TestDataSource.InsertCommand = "INSERT INTO Email(EmailAddress, IPAddress, DateTimeStamp) VALUES (@EmailAddress,@IPAddress,@DateTimeStamp)"
 TestDataSource.InsertParameters.Add("EmailAddress", emailAddressTextBox.Text)
TestDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString())TestDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now())
 Dim rowsAffected As Integer = 0
 
Try
rowsAffected = TestDataSource.Insert()
 Catch ex As Exception
 Server.Transfer("test_problem.aspx")
 
Finally
 
TestDataSource = Nothing
 
End Try
 
If rowsAffected <> 1 ThenServer.Transfer("test_problem.aspx")
ElseServer.Transfer("Test_Confirm.aspx")
 
End If
 
 
 
End Sub

View 2 Replies View Related

SQL Cant Find Server/instance When Deploying Website.

Mar 11, 2008

Hello All, please be gentle im very new to this stuff..
So if i add a record via a sql datasource using the ConnectDB connection string it adds it the the sql 2005 database called intranet.... If i try to add to it using an onbuttonlick(Code Below) event it comes up with the "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 have set remote connections on and tryed it with TCP/IP and TCP/IP and Named Pipes.   SQL is installed as the default instance.
If  both ways are using the same connection string surely it should work? Im not to sure where i am going wrong here...Here is the code for the on button click event.. 'INSERT NEW EMAIL INTO NEWSLETTER TABLE




1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

Protected Sub AddEmailButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles AddEmailButton.Click
Dim ConSTRING As String = ConfigurationManager.ConnectionStrings("ConnectDB").ConnectionString
'INSERT NEW EMAIL INTO NEWSLETTER TABLE
Dim cn As SqlConnection = New SqlConnection(ConSTRING)
Dim InsertSQL As String = "INSERT INTO Newsletter (Name, Email) VALUES (@Name, @Email)"
Dim cmd As SqlCommand = New SqlCommand(InsertSQL, cn)
cmd.Parameters.AddWithValue("@Name", (TBname.Text))
cmd.Parameters.AddWithValue("@Email", (TBemail.Text))
cn.Open()
cmd.ExecuteNonQuery()
LBLstatus.Text = "Success, Email is now on Mailing List"
cn.Close()

Below is my web.config connection string<connectionStrings>  <remove name="LocalSqlServer" />  <add name="ConnectDB" connectionString="Data Source=10.130.0.11;Initial Catalog=intranet;User ID=XXXXX;Password=XXXXX;"   providerName="System.Data.SqlClient" /> </connectionStrings>
 
Any help on this would be great as im stuck..
Best Regards
Leigh

View 5 Replies View Related

Adding SQL Server Database File To The Website

Apr 12, 2005

Hi!!!
I have a database called "test_DB" i have one table and some data on it. I uploaded the website and created an SQL Server account to upload the database. Can you please help me to do that task. Is there any step by step directions to do it and what files i need  to add  ( like ".mdf" or others...) I appreciate your help!!!
Thanks...

View 1 Replies View Related

Website Navigation Hierarchy With SQL Server 2005

Mar 24, 2006

HiI'm trying to convert some verbose SQL Server 2000 T-SQL code that useslots temp tables and the like into a SQL Server 2005 only version,possibly using CTE.What I want to achieve is a menu like that onhttp://www.cancerline.com/cancerlin...9801_6_3_3.aspxNotice how you have the top level menu items, and then child nodesexpanded down to the low level page that link sends you to.Table sql:CREATE TABLE [dbo].[NavigationNode]([NodeId] [int] primary key nonclustered,[Text] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[AlternativeText] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_ASNULL,[Level] [int] NULL,[ParentNodeId] [int] constraint fk_parent_navnodeforeign key references [NavigationNode] ([NodeId]))Table data:1HomeNULL1NULL2SolutionsNULL113Solutions child1NULL224Solutions child2NULL225ContactNULL116solutions child1 child1NULL337solutions child1 child2NULL338solutions child1 child3NULL339solutions child1 child4NULL3310contact child1NULL25I have started to write some code with the common table expressionsyntax:declare @root int;set @root = 2;WITH Nav([NodeId],[ParentNodeId], [Text], [Level]) AS(SELECT [NodeId], [ParentNodeId], [Text], [Level]FROM [dbo].[NavigationNode]WHERE [ParentNodeId] = @rootUNION ALLSELECT n1.[NodeId], n1.[ParentNodeId], n1.[Text], n1.[Level]FROM [dbo].[NavigationNode] n1INNER JOIN Nav n2ON n1.[ParentNodeId] = n2.[NodeId])SELECT *FROM NavWhich returns:32Solutions child1242Solutions child2263solutions child1 child1373solutions child1 child2383solutions child1 child3393solutions child1 child43However I would prefer to the childnode, and then get parents of thatchild recursively. Doing that would leave me with a result set thatcould add the top level menu items to and have all the data required.Any help is greatly appreciated.-Brian

View 1 Replies View Related

Not Able To Download Sql Server 2005 Sp2 From The Microsoft Website

May 10, 2007





Dear members



I am using window vista and I am not able to download the SP2 for sql server 2005.

every time there is a message age can't be displayed.



from where I can download the sp2



thanks in advance

View 1 Replies View Related

Access SQL Server 2005 Database Using A Published Website

Jun 26, 2006

Hi all,
 I am stuck with a problem using ASP.Net website. I created a website which accesses a database table in SQL Server 2005. The default.aspx is a form which inserts/updates/deletes data from the database. After creating the website I published it to IIS (Inetpub -> wwwroot). When I use Visual Studio 2005 and build the website and start with debugging. the form comes up and i can insert/update or delete the data from the table as I want. Now, as I have the website published I can access the form from another sharepoint website using the url as
/Employee_Data/Default.aspx">http://<mydesktop>/Employee_Data/Default.aspx
the form shows up but I am not able to access any of the database. I do not see any errors either. Once I click on the button the page just refreshes but nothing else happens. I have my web.config as :-
<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings/>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
</system.web>
</configuration>
 
Am I missing something? I even have Anonymous access in the IIS inetpub properties. I can even the database as I am the administrator..... I appreciate your suggestions.
 
Thanks,
Kavya

View 1 Replies View Related

Updating Aspnetdb.mdf Once It Is Launched To The Website Hosting Server

Oct 5, 2006

I'm having my website hosted with webhost4life.com which is very helpful and a really great company if you are using Visual Web Developer with SQL Express.  The question I have for anyone who can help me is that my site will offer member roles for customer account maintenance with login and the works.  As you know, when you use memberships with Visual Web Developer, it associates all these controls with a database called aspnetdb.mdf.  And you maintain this database through the asp.net configuration control.  Once this database is launched, I've learned how to access it by changing my web.config file removing the LocalSQLServer and adding one with the connection string to the aspnetdb.mdf database on the server.  My question is, once I've done this and connected through that string, can I still use the asp.net configuration to edit the database (e.g. the users, roles, etc)?

View 1 Replies View Related

Problems Opening SQL Server 2000 Connection From Website

Feb 15, 2007

I am getting the error message below when trying to connect to SQL Server 2000.  Here are the details:

Problem is occuring with a new website trying to connect to SQL Server.  The error occurs right at the open statement.
Using SQL Server 2000
Web server is on a different machine than SQL Server
I have many websites connecting to this SQL Server.  Websites are all on the same webserver.
I can connect to this SQL Server using the Query Analyzer using the same ID  and  PW as in my connection string
My web application runs OK using this SQL Server when I run it from my laptop - just changed the connection string Initial Catalog parameter.
Any help would be appreciated.
 Jay
---
 Error Message
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

View 6 Replies View Related

SQL Server Error - Trying To Deploy Personal Website Package

Apr 20, 2007

After using FTP to transfer my site to Dotster, I get an error upon running the site. Here are the source error and stack trace respectively:
Line 5:  void Application_Start(object sender, EventArgs e) {Line 6:  SiteMap.SiteMapResolve += new SiteMapResolveEventHandler(AppendQueryString);Line 7:  if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");Line 8:  if (!Roles.RoleExists("Friends")) Roles.CreateRole("Friends"); 
[SqlException (0x80131904): 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 host provider says I must create the database [on their server] using their on-line utility, Is this true? Or do I need to configure the server to allow remote connections? If the latter is true, how is it accomplished?
Thanks in advance.... any help is appreciated.
 

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved