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?
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
My ASP.NET application runs fine within the VS2005 IDE; but, when I deploy to my local machine to try to run it under IIS and calling it up in a browser, I'm getting the following exception:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92 System.Web.UI.WebControls.ListControl.PerformSelect() +31 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
I'm a novice at this and really need some help. What stupid newbie mistake am I making here? Thanks in advance for any guidance/assistance rendered.
I have built a site that uses form-based authentication. Am I correct in assuming that the users and passwords will be stored in the SQLServer database in the aspnetdb.mdf file? The website works great and the authentication works how I want it to. However, I've tried to copy over the file onto a remote machine. The first page is a login screen and this is displayed without any problems but as soon as I attempt to log in I get an error message of: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'm wondering if this is something to do with the fact I installed SQLServer Express edition on the remote machine. The website works no problem on the local machine in debug mode of Visual Studio 2005 (Professional Edition). I followed instructions to enable remote connections on SQLServer Express from a Microsoft support doc. If anybody can point me in the right direction I'll be very grateful as I've hit a wall here.
Hi,
I am new to asp.net.I am trying to deploy the website on IIS created in visual web developer 2005 express.I am having problem with the aspnetdb.mdf for login.I have copied my entire contents to the physical directory( shared floder),from where the iis virtual directory can access the contents.I can see my login form but when i enter my username and password and click login it gives my error"error occured in establishing the connection".
I am using the sql server 2005.I don't know what should i do with aspnetdb.mdf?
thanks and urgent help needed
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?
How do I access the SQL server from a website, using my Machine Account, not the ASP.NET account?
thanks.
.intrino.
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.
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
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.
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 Relatedi 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)
What application/software can be used to conect a website to a sql server 200 backend.
Thanks!!
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
I am looking for sql server certifcation questions any one hasany.like dumps or some thing
View 1 Replies View Related
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
Hi Well this is my first post on this forum, in fact I have not even used SQL Server yet!
My question is.... I have been asked to produce an application which will be a VB6 application with an SQL Server database behind it. I would like to be able to put the application along with the database on to a CD and run them directly from the CD once it is distributed. So the question I guess is can this be done with SQL Server i.e. can a table be exported in a format which will allow it to be queried in a standalone fashion? Maybe I have not explained myself properly but I welcome any questions which will help clarify my problem.
Thanks Red
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.
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
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 Relatedhi 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
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...
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
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
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
Guys,
Let me first give you a little bit of background...
One of my goals for this year is to migrate all DTS packages to SSIS, those DTS packages are used across the company by different groups/users.
Since I'm still not that familiar with SSIS and like many here, was well used to the enterprise manager view (all DTS packages on 1 single place), I'm unsure on how to structure my SSIS packages in a way that I could break it down by group let's say.
The way that I'm doing right now is: I'm creating a solution for each group and creating the SSIS packages (.dtsx) relative to that group inside each solution, that's pretty easy. Now, the next thing that I'll have to figure out (and hope you guys can help) is how to deploy them structured this way and how to handle these packages to my end users. Basically, how do I handle "Group A" all of their SSIS packages? Will they have to open the package in debug mode on VS every time they need to execute a package?
Thoughts on this?
I have installed SSRS on my local machine with all default settings. Report manager and report server and reportserver data base and reportservertempDB all are in my local machine. Now I have already created few reports. but now the company wants to deploy them to the main server. Now can I do this? Do I have to chage the report configuration settings. Does it effect to my current reports?
If this is possible, can anyone tell me how to do this please?
Thanks
I have developed a windows mobile 5.0 application that is currently syncing with sql server 2005. I want to deploy the application with sql server express for the client. What do I need to do to make this work?
Thank you.
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
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 RelatedI 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)
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.
I found an article on the CodeProject website named T-SQL MapReduce. I'm trying to duplicate the SQL code there into a SQL Server 2914 Developer Edition database I've got, and also the C# code using Visual Studio. I've defined the user data types fine (e.g.: word_t, words_t and so on), but I got an error when I tried to create the UDF dbo.mapper from the page. The error I got was:
Msg 102, Level 15, State 1, Procedure mapper, Line 5
Incorrect syntax near 'CALLER'.
The SQL code I used is straight off of the page; it looks like this:
[code=sql]
create function dbo.mapper(@documents DocumentsWithAutoIncrementIndexTable READONLY, @sep nvarchar)
returns @t TABLE ( wordindex int, word word_t )
WITH EXECUTE AS CALLER
[/code]
What have I done wrong? I'm guessing that the author has done something like left off a variable declaration or something like that. what am I missing?