Hi everybody,
Currently we have a MIS application, developed in VB 6.0 - SQL Server 2000 platform, which is used by around 60 users in our office.
We are planning to host a website remotely, which would allow clients to place orders, track order status etc. on it.
Would it be possible to access our local SQL database from the remote website?
Hi,
View 1 Replies View RelatedHi,
How do I insert data that I have collected in a local database onto a table on my online ie hosted database which is on a different server?
At the moment I am just uploading all the data to the hosted DB but this is wasting bandwith as only a small percentage of data is actually selected and used.
I thought that if i used a local DB and then update the table on my hosted DB this would be much more efficient, but I am not sure how to write the SQL code to do this!
Do I do some kind of
INSERT INTO sample_table
SELECT xxx
FROM origanal_table
Or is it more complicated than this?
Thanks
Hi,I'm running Visual Web Developer 2005 and have created a small site with a log-in function. In VWD this automatically creates the database ASPNETDB.mdf which stores all the user / log-on data.I have 1 x MS SQL Server 2005 DB which I am using to store data for my site.Can anyone advise me on how to setup my site / the ASPNetDB so that it runs on my MS SQL Server?I've searched the ASP.NET forums etc and this does seem to be an area where people are struggling. I have tried running the ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe) and get the following error:"Setup failed.Exception:An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 8152 and the SqlException message is: String or binary data would be truncated."As a beginner I've struggled from downloading an online template, then uploading it to my site, and the log-on doesn't work. There didn't seem any instructions / advice on what to do with the ASPNETDB.mdf database.Help / advice would be much appreciated!Thanks,Tom
View 2 Replies View RelatedAll,
My ISP does not allow me to remotely connect to my hosted SQL Server DB--how can I use SQLDataSource and other data bound controls in development?
Here are my specs:
IDE: Visual Web Developer Express 2005
Database: MS SQL Server
ASP Version: ASP.NET 2.0
The SQL Server is hosted centrally at the ISP; basically I have been given the connection string parameters.
My question is this:
Do I use two web.config files (one for when I develop locally and one for when I deploy remotely)? If so, how? Will the SQLDataSource control find the connection string defined in web.config on the remote server? I don't want to have to write all of the database code and it would be a big loss of one of the major benefits of using ASP.NET 2.0 if I do.
Any help will be greatly appreciated,
Leslie
I have a SQL Server 2005 database hosted by a provider that has about 500 databases on their site. I am running Access2007 on a Windows 7 Home Premium edition.
What I am trying to do is create a new Access2007 application and attach (i.e: Link) to the SQL Server tables. I am using SQL Authentication.
I have done this before where i attached via ODBC to Oracle, but it was on the corporate network - not on a hosted server. When i try to walk thru the Access process, it does not seem to let me give it the database name. I have the connection string i use in C# (for example: Data Source, Initial Catalog, UserID and Password), how to connect with Access2007.
Hi,
Can anyone please tell me how to access a SQL server database remotely. I have
the IP address and login info. of the NT machine that is running SQL server
database, and I want to access the data remotely.
Thanks for any help.
Chetan
I have a problem when trying to save a transaction remotely. I'm using my pc as the server and I can save without any problem from local (the same project).
But when I try accessing the project from other pc, the transaction doesn't get saved into the db.
No error displayed. It's just doesn't get saved. What is the problem? Is there any IIS setting that I should put in?
One of my tables in the db contains the websites and the location of their link directory. i.e. domain.com/linkdirectory
I want to run a check against every website's robots.txt file to ensure that it doesn't look like this:
user-agent: *
Disallow: /linkdirectory/
so I need a program that does the following:
For each website in database (start of loop)
Does robots.txt exist on their site ?(run a remote check)
if it does
is their link directory blocked in robots.txt?
if so, then log their user id and website name into an array for later use
end if
endif
end loop
How would I do this in ASP.net 2.0?
I'm using Visual Studio 2005 (8.0.50727.42) and going into the menu option Website > ASP.Net Configuration, access the security tab and all I get is an error message stating that there is a problem with the selected data store "Unable to Connect to the SQL Server Database"
I have SQL Server 2005 (Express Edition). I have created a database "NetDev" with the right connection, etc.
I can use the SQL server fine for my Windows applications, but somehow this ASp.Net Configuration tool is not making any sense.
I also used the aspnet_regsql command from framework 2.0 to create a DataBase to no avail.
Does anyone out there knows if there is a bug with this tool???
Is there any way to backup a remote SQL Server that is on a hosted account to a local drive? We have a web hosted account that has a SQL Server that we do not have full admin rights on, just dbo access to the data and structure. We would like to be able to do backups and restores to our local development server if possible. Perhaps vis DTS or some similar means? WE cannot use the normal backup/restore as we do not have right to these fucntions nor can we access the servers local drives directly.
View 2 Replies View RelatedHi, I hope you can help.I have configured a Windows 2003 web server and SQL 2005 Server (on same box) to successfully allow remote connections and to allow access via SQL Server Management Studio Express 2005.The problem I have is that I want to restrict access to the databases on the server via the Management Studio to specific databases e.g. 1 database user "sees" only 1 database.I can configure it so that the user's remote access permissions do not allow access to other databases but they can still "see" the database listed in the Management Studio explorer.I can also configure it so that the users cannot see all the databases (by disabling View All Databases on SQL Server), but this means that they cannot not see their own database which they have permissions for.Is it impossible to have the desired behaviour of only displaying the database which the remote user accessing has permissions for and hiding all other databases?I have MSN'd,Googled and Yahoo'd this one to no avail :(Many thanksFergus
View 6 Replies View RelatedHi 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
Hello,
I have a local SQL Server database installed with Visual Studio .NET. I'm trying to create a SQL Server login ID to access a database on this local database. I gave it access to all of the databases with public (the one I'm using it also has DBO and execute permissions on all procs). When I try to login to it through SQL Server Query Analyzer (and also using an ASP.NET application), I get the following error:
Login failed for 'dbuser'. Reason: Not associated with a trusted SQL Server connection.
How do I set up a SQL Server login to access the database?
Thanks,
Brian
I am newbie to SQL.I need to create an application will run on server, and of course will be installed by using admin user. I can use the install user to access to database on that server?
View 1 Replies View RelatedI've created a local server from Sql Express, and report server from Reporting service configuration manager, and than publish a report on the local report server. I want to give access to the other computer user to the sql reports, database and report server.
View 0 Replies View Related
Hi 2 All,
I have installed MS SQL 2005 in my system. I have created one database in my server. When iam running my application with this connections it is working fine in my local system. When i uploaded the database to some where dataserver, Iam not getting the connectins due to no remote access .
Some body suggested that to start the SQL browser in the SQL Server Configuration Manager.
I go there n tried to start the service when i put the service properties to Automatic or Manual i am getting the error message that is saying that the service is disabled cannot start automatically.
What could be the wrong?
Please suggest me.
Thanks and regards,
I have written a intranet page that writes some info into a sql database, basically following the 'SQL Server 2005 Express for Beginners' video.When I debug the application from within 'Visual Web Develop 2005 express' it works fine entries are entered into the DB and I can then edit the db using the admin page.But when I host the site using IIS I doesn't work, submissions to the database seem to fail I can see the DB in the admin page but if I try to edit them or delete them it fails. What could I doing wrong could I be missing a setting in IIS? Any ideas??Here's my webconfig if that helps at all: <?xml version="1.0"?><configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"> <connectionStrings> <add name="studentprofilesConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|studentprofiles.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings> <system.web> <roleManager defaultProvider="AspNetWindowsTokenRoleProvider" /> <compilation debug="true" defaultLanguage="c#" /></system.web></configuration>
View 1 Replies View RelatedHello, I am new to SQL Server Express, I am trying to upscale my database/Application to a SQL Server/Application with C#. All I want is to create a SQL Server service on my Office Server and manage it via my station. But I keep getting this error:
TITLE: Connect to Server
Cannot connect to SERVER.
ADDITIONAL INFORMATION:
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)
The thing is that I went on the Server in the Surface Area Manager, I allowed IP and and Name pipes on network. Still does not work.
When I open the Manager from my station, I see the Server but keep getting this error.
Can someone please help me. Thank you
Currently I am being told that for someone to remotely view reports that are stored in RS an individual needs to login to a PC's OS with the correct domain and user name. When they launch the browser it will them allow them access to the reports stored in RS.
This seems to limit the capabilities for a remote access
Can you go to any PC anwhere, type in the URL, and get a prompt for user name and password for access?
Will the user name and password allow restrictions to what you can see?
Is there anwhere where I can see an example of this? Like a dummy site or something?
I really appreaciate the help!
Mark
Phoenix
I can't run my web application on remote pc which is connected in flan with my pc.It works on my local pc but it is not working on remote pc. i m geeting an error like as blowAn 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) i have used sql server 2000 for my database but i my getting error for sql server 2005 which i have never used in my web application.Here is the Exception detailsException 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)i have used coonection string as followsData Source=neptune;Initial Catalog=azim;User ID=saso can anyone give me soluion of this problem
View 1 Replies View RelatedI have a named instance of MSDE running on my windows 2k3 web server. I can connect just fine using ODBC to that DB whailst I am on the server.
I would like to be able to create an ODBC connection from my local machine (running Windows XP pro) to the MSDE database on my server but I can't get it going.
I have heard that I need to edit the registry but a Google search warns that this could be a vulnerability...
How do I do it without compromising the security of my web server?
TIA
hi,
how can i publish my RS2005 reports with asp.net(2005) application.I am trying by creating virtual directory ,the aspx page runs but it is unable to access reports from report server
Is there any article on how can i deploy report with asp.net so that i can access report using aspx page remotely
pls suggest me
Hello,
Only the server administrator user can connect to SSIS from remote workstations. All other users encounter "Access denied". What security settings are necessary to permit regular user access to SSIS? Firewalling is not an issue. SSIS is running and works fully for the server administrator user. All users can manage the Database with SSMS just fine; only SSIS cannot be accessed by regular users.
Server Configuration Notes:
Windows Server 2003
SQL Server 2005 Standard
Workstation Configuraiton Notes:
Windows XP Professional
SSMS (installed from the SS2005 media)
Thank you.
I am tring to access the SQL 2005 Express which installed in remote machine. Front end app is on Visual Studio 2005. Try to connect SQL Express using the application Layer which is installed on the computer where SQL Express is installed. Could not fetch data from the SQL Express. What could be the problem?
With Regards,
ADK
Hi,
I need the code to create a connection between the Sql server using ACCESS form.
Can I do this. If yes . can you help mw with it.
Currently I am accessing the server with remote desktop connection
Regards,
Jay
How do I access the SQL server from a website, using my Machine Account, not the ASP.NET account?
thanks.
.intrino.
I upgraded from msde to sql server express. Everything seems to work just fine. I can odbc to the database servver and can view website from local server but cannot access website from remote server. It gives me Cannot find server error.
Help is appreciated.
Good Day,
I am creating a SQL Named instance as a testing environment. This instance is on the same physical box as my Development environment, both are SQL 2005 standard edition. From the server in Management Studio, I can load, and interact with both instances. From a remote connection (e.g., my pc) I cannot access the named instance. I am getting the following:
Connect to Server
X Cannot connect to <server><named instance>
Additional Information
An error has occured while establishing a connection to the server. When connecting to SQL Sever 2006, 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)(Microsoft SQL Server)
I have checked, and rechecked the server settings for this named instance, and remote connections are set to "allow" I have enabled TCPIP and Named Pipes prototocals, and have ensured that my firewall is allowing the "listenting port" for the named instance, and have even tried turning off my XP firewall during testing.
I am sure that I have probably missed something, and have searched the community but only have been able to find resolutions that I have already tried. Is there more?
Thanks in advance for any help and guidance you can provide.
I've tried everything. The CreateUserWizard works fine, but then, I didn't have to connect anything for that. I've tried both SQLServer and MySQL. Connection Strings are correct, everything is correct as far as I can see. I've followed every step many many times. I'm about to go back to the old style and use VB6, because this is just stupid. The error I get is "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)" If anyone could help me out with this I'd really appreciate it.
View 6 Replies View RelatedHello,
I am working on an ASP.NET apllication which will work with sensitve data that needs stored as encrypted. The ASP.NET application and SQL Server 2005 will be hosted outside of our company.
My questions are:
When I create a database master key, a certificate and a symetric key to encrypt and decrypt my data, will I be able to use these (master key, cert and symetric key) in other databases (say my local development SQL Server 2005 instance)?
Is a managed hosting a better solution to have total control over the the keys in the database?
Is there a white paper or guidance document for security in hosted databases?Thanks
-Al
Hello,
I would like to know whether is it possible to administer a database on a hosted site - i.e inserting some lines, executing a query. I normally access the files via ftp connection. And so far the only way I figured I can mess around with the database is to download it and change it on my desktop PC.
Thank You.
Tomáš Pajonk
What is the best way to insert records into an SQL Server 2005 database that's being hosted with my website. The data will originate from customer sites as transactions. Do I connect to the hosted database using TCP/IP or do I create web pages that accept the data variables? This is all new to me!
I need this to happen unattended and 24/7/365
Thanks
Tim