I have SQL Server 2000 installed on XP Pro and I am having problems connecting from an ASP.Net application.
The DB in question was exported from my laptop, which is running MSDE on Windows 2000. On that machine Trusted_Connection=true seems to work from the ASP.Net application whereas the SQL Server login that I set up does not.
Now that the DB has been imported to my XP machine, Trusted_Connection=true no longer seems to work. I am assuming that this may be related to the same problem I had when I was trying to use system logs - the ASPNET user does not have the same privileges on XP as it does on 2000.
In any case, I'm not too concerned at the moment how I connect, just as long as I am able. So, I again tried using the SQL login I had set up with no success.
(I added the SQL Login at the server level then I added it at the DB level and granted it public, db_datareader and db_datawriter access. Later, when that didn't work, I also granted it db_owner rights. Still no success. (BTW, I remembered to repeat these steps on my XP machine once I had imported the DB.))
Then I thought to try using 'sa'. To make sure I that remembered the sa password, I logged into Enterprise Manager (which, I assume uses Windows authentication) and changed it. Then, I went over to Web Data Administrator and tried to log in, using the SQL Login option, with sa and the password that I had just set - IT DIDN'T WORK.
Am I going mad, or is there something I'm missing?
Hi there I sorry if I have placed this query in the wrong place. I'm getting to grips with ASP.net 2, slowly but surely! When i try to access my site which uses a Sql Server 2005 express DB i am receiving the following error:
Server Error in '/jarebu/site1' Application.
Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'. 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: Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.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:
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
This is the connection string that I am using: <connectionStrings> <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;Initial Catalog=ASPNETDB;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings>
The database is definitly in the folder that the error message relates to. What I'm finding confusing is that the connection string seems to be finding "aranga"s database. Is it something daft?
Hi, I am new to DTS. I am also not sure whether this is the solution for my criteria. First my criteria. I have an Excel file where i would be capturing the data on a daily/weekly basis. Now, i want to transfer the data to sqlserver at a regular interval let me say weekly once. I want the record to append. At later stages, planned to call from asp through asp.net. Which is the best solution for to accomplish this task. Any good sample would be of great help. Thanks in Advance to all.
Hi , My company will have a new application running On an NT Cluster .It has MICrosoft SQL 6.5 as its core element .I have been given Two Months to know Microsoft SQL 6.5 inside out .( commands configurationa and all ) .Please does anyone know any good books on Microsoft SQL 6.5 and knowing SQL thoroughly . Please help HAPPY NEW YEAR . Thanks in anticipation . Mibsun
I have a bunch of .sql files that will create a data model for me. I've created a new database in my SQL Server 7 Enterprise Manager called Test. How do i run this script? In part it looks like:
Hello. I'm new to SQL server and I've run into a really basic issue. I'm working on a Visual Studio 2005 project and I have a SQL databse with a .BAK extension I need to use with the project. I've read online that I need to restore the database to a new database to work with SQL Server Express. Here's where I am lost. I can't find good instructions on how to restore the DB to a new one. Any help is really appreciated. Thanks.
Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.
I am migrating a access dbase to SQL. I have two tables, the first is a buffer table that collects data from various sources, the second table is an indexed version of the first table (to eliminate duplicate records etc. etc.)
I am currently using the DTS packaage to transfer data between them, would a trigger be a better solution?
I am migrating a access dbase to SQL. I have two tables, the first is a buffer table that collects data from various sources, the second table is an indexed version of the first table (to eliminate duplicate records etc. etc.)
I am currently using the DTS packaage to transfer data between them, would a trigger be a better solution?
I currently have Apache, MySQL and php running on my local machine to enable me to test php code on localhost
I've been asked by a colleague if I'll work on an SQL 2000 database they're having trouble with. They said they will provide Visual.net, SQL 2000 and any other software I need.
I'm completely in the dark on this, but have some starting questions:
To test my code, will I need to set up a sever on localhost?
Will I need other software than Visual.net and SQL 2000? I'm using DW MX for my web stuff.
Whre can I find a basic introduction to ASP / SQL 2000 in the form of a tutorial?
How fast does this combination run? The database has 25,000 rows and 6 columns. What would be a reasonal expect time for a result?
Hi, I am totally a newbie to MS SQL. I have a question regarding the MS SQL: What is the difference between the MS SQL and the SQL Server? Is it the same? and what should be install for MS SQL on the server and the client side???
I am relatively new to SQL Server and I have 2005. I am developing a database with an Access ADP frontend. The development is taking place on my laptop running a separate instance of SQL Server. I am trying to put the database on the production server and I am not sure how to proceed.
My laptop is not part of the network so I need to create a file and then import it on the SQL Server instance running on the production server. I thought I could do a backup and restore, but apparently that is not working.
i'm new at MS SQL Server, i developed an application with MS SQL Server Developer Edtn. and i want to try it with a real server and clients
i tried to install it to WinXP Pro and it asks a domain and a user account, is theere a way to create a domain with winxp pro, or working with only server windows (2003 server, 2000 server etc.). If it is working with only server, is there a tutorial at internet to create a domain and users at windows (i lost lots of time to setup Ms SQL Server) pls i need a tutorial, or a way to install MS SQL Server...
i want to install ms sql server to vmware machine, i wonder how to make configurations to access my server on real machine and other machines that is on the network of real machine (i think i must user pat, but how to make configurations is a big problem, but the biggest is installing sql server)
it is urgent pls help, i dont want to lose more time because i lost enough...
I'm in a slightly sticky situation. I recently got a job I interviewed for as a business analyst/programmer. I know quite a bit of VB 6.0 and SQL language, also enough access to build a decent database as a backend for my apps. I've recently received a 4 yr CIS degree, so I know a little about everything. I told them very clearly three times in the interview that I'd never built a SQL Server DB, but they must not have cared about that. They need someone who can program, do some DB work, and also do some business analysis. I was the best fit they could find.
After working with the group a few days, I figured out they need a data warehouse and marts to do some historical analysis, and eventually data mining and trend analysis, etc. I think they said they'd like to have that by the end of next year.
What I need now is one or two really great books to get started with, and a small synopsis on what I'm going to need as far as dev software and server specifics to get this thing off the ground. The first thing they would like to see is simply enough tables to dump data into from 4 or 5 different DBs, from which they can pull data for analysis whenever they need to do so. The total rows for this DB will be around 170mil, but with just a few measures in each row. Microsoft spreadsheet says I should expect about 5gig per year of data.
So I'm freaking out because I know ziltch about SQL Server, what tools and server set up I'm going to need, and the more I read, the less it sounds like "Oh it's not that big of a deal. It's easy", as a few friends told me.
Hi, I always had the impression to use asp.net membership, in sql server, I needed dbo permission because all its tables and what not always had [dbo] in front of them and "dbo." is all hard coded into their build-in membership classes. In my shared hosting enviornment, I always had to ask my db admin to give me dbo permission explicitly. I saw this article today http://www.aquesthosting.com/HowTo/Sql2005/Providers.aspx and after I followed their direction, by using ec sp_addrolemember 'aspnet_Membership_FullAccess', 'yourUser' go Exec sp_addrolemember 'aspnet_Personalization_FullAccess', 'yourUser' go Exec sp_addrolemember 'aspnet_Profile_FullAccess', 'yourUser' go Exec sp_addrolemember 'aspnet_Roles_FullAccess', 'yourUser' go Exec sp_addrolemember 'aspnet_WebEvent_FullAccess', 'yourUser' got
Hi, I have a very newbie question.I have been only developing websites locally on my computer (during my learning curve) and never actually put anything up in a server on internet, but I just bought a server from discountasp.net and an extra SQL 2005 Database.Now I need to put my database on that server (copy the local one) I know I have a connection string and username and password. But I really do not have any ideas how to do this.I would appreciate if you tell me where to start and what I should do at this stage.Thank you and have a good day.
Does anybody could show me how to connect my Excel 97 to MS SQL Server 7 using ODBC? What are the MS Office Components needed for the connection and the necesary MS SQL server component, server and client, needed?
I am trying to learn MS Sql Server and MS VB, ASP, .Net, etc., have installed SQL Server 2005 and Visual Studio 2005 on an XP Pro machine. I find fairly good MSDN help with VB & ASP stuff, but not with SQL Server. Can anyone recommend a good place to start, like online tutorials, or training, or even a good basic book that can show me how to create db’s, tables, load data, basic stuff like that?
I have installed SQL6.5 on my NT4.0 server. I go into the enterprise manager. There are currently no registered servers. I try to add a server under the SQL 6.5 group and get the following message:
"Unable to connect to Server(reason [SQL Server Login failed]. Register Anyway?"
The service is running. I can login through the command prompt, but when I type select @@servername it comes back as NULL. I have tried both my NT SA account as well as the SQLExecutiveCmdExec account. TIA - pwb
Relatively new to SQL, will be using it as the engine for a dynamic website...I have a database in Access that is the foundation for this site -- it's pretty simple, just a few tables with relationships established & a couple of queries.
Is there a tool that can migrate this Access db into SQL, or should I just reconstruct it? Been looking around for some tech notes and have been unsuccessful so far. Thanks in advance! -Valerie
I've seen this question asked when I searched, but I didn't see an answer that looked like it applied to me, so I'll ask again.....
Making the transition from VB 6 to VB.NET and decided to take a stab at database programming while I'm at it. I bought "Database Programming with Visual Basic.NET and ADO.NET" by Sams Publishing and ran into problems in the first chapter. I've posted some questions on the microsoft.public.vb.database newsgroup and got some help, but it's still not working.
I'll skip some of the boring stuff and dive right in with what I've found out so far:
From MSSQL$VSDOTNETLOGERRORLOG
2004-11-19 02:29:34.71 spid3 SQL global counter collection task is created. 2004-11-19 02:29:34.76 spid3 Warning: override, autoexec procedures skipped. 2004-11-19 02:29:58.87 spid51 Error: 15457, Severity: 0, State: 1 2004-11-19 02:29:58.87 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.. 2004-11-19 02:29:59.01 spid51 Error: 15457, Severity: 0, State: 1 2004-11-19 02:29:59.01 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.. 2004-11-19 02:29:59.46 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
The last suggestion was to uninstall and reinstall. I uninstalled VS and SQL and reinstalled getting the same error message in the log, but the message box said that installation was complete.
On the Server Explorer of the IDE, it shows my computers name (programmer) under Servers. When I expand that and expand SQL Servers, I see PROGRAMMERVSDOTNET. When I try to expand that, I get the SQL Server Login window with Server textbox disabled saying PROGRAMMERVSDOTNET and the Database blank. Under the Login it has James (my sign in name) and asks for a password. When I did the MS-DOS CLI installation, I used "password" as the SAPWD. I tried using password, and tried using the password to log on as James, and get the same error message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Any help would be appreciated, as long as you remember that I am a COMPLETE newbie at this. I'm fairly computer literate, but I don't know the first thing about databases.....
Hi. I just set up my first sql server database and I've managed to connect to it via ASP as a test. I'm not sure how to add data to my tables. In MS Access, you can edit the table and add records. How do I do that in SQL Server? I'm using the Enterprise manager tool to create tables.... does it have something i can use?
I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.
While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.
I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.
I am able to do these actions interactively from SQL 2005 (not developers nor enterprise edition, just using SQL 2005 Mgmt Studio) and want to "script/batch" them so I can have them automatically run at a pre selected time.
First: I am able to delete the table by performing a right click on the table, then click Delete from Mgmt Studio SQL 2005. I verify the table is completely gone with a refresh. (I pulled the code that did this ..... DROP TABLE etc. to Notepad)
2nd: I am able to import the table (again from Mgmt Studio SQL 2005) and have saved this action as a SSIS. Execute the script and "waLa" I have all 17K rows of data. I pulled this create table code into notepad also.
Now I put the code of both of the above actions together (drop table and create table) into one SQL query and execute it. This does not give me the same results of above, instead my table is blank now.
Maybe there is a better way. The business problem I am attempting to solve: I am refreshing the data in a as/400 table weekly. I want that refreshed data to be available in the SQL2005 database without my having to press buttons first thing Monday morning. Can any one help? Thanks in advance.
Below is the Code:
USE [400kas] GO /****** Object: Table [dbo].[navar100] Script Date: 09/07/2007 16:09:04 ******/ DROP TABLE [dbo].[navar100] GO
USE [400kas] GO /****** Object: Table [dbo].[Query] Script Date: 09/07/2007 16:12:31 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[navar100]( [CMPNO] [decimal](3, 0) NOT NULL, [ARTDT] [datetime] NOT NULL, [AUDDT] [datetime] NOT NULL, [ARDDT] [datetime] NOT NULL, [CCUS#] [decimal](6, 0) NOT NULL, [CCNAM] [nvarchar](25) NOT NULL, [CUSNO] [decimal](6, 0) NOT NULL, [CNAME] [nvarchar](25) NOT NULL, [SHPNO] [decimal](4, 0) NOT NULL, [ARRCD] [nvarchar](1) NOT NULL, [AUDUS] [nvarchar](10) NOT NULL, [INVNO] [decimal](6, 0) NOT NULL, [CUSPO] [nvarchar](15) NOT NULL, [REFNO] [decimal](6, 0) NOT NULL, [COMNT] [nvarchar](10) NOT NULL, [SHPPO] [nvarchar](15) NOT NULL, [AMONT] [decimal](13, 2) NOT NULL, [AMOUNT] [decimal](24, 8) NOT NULL, [REMAN] [decimal](13, 2) NOT NULL, [INREG] [decimal](3, 0) NOT NULL, [INSAL] [decimal](3, 0) NOT NULL, [TMCOD] [nvarchar](2) NOT NULL, [CRHLD] [nvarchar](1) NOT NULL, [CRLIM] [decimal](13, 0) NOT NULL, [CRDAY] [decimal](3, 0) NOT NULL, [TCRCD] [nvarchar](3) NOT NULL, [TEXRT] [decimal](11, 6) NOT NULL, [R1RGL] [decimal](13, 2) NOT NULL, [TAXAM] [decimal](13, 2) NOT NULL, [TFRTX] [decimal](13, 3) NOT NULL, [TFRGT] [decimal](13, 2) NOT NULL, [TSPCH] [decimal](13, 2) NOT NULL, [SPCST] [decimal](13, 2) NOT NULL, [IRPFT] [decimal](13, 2) NOT NULL ) ON [PRIMARY]
i downloaded and installed SQL SERVER 2005 EXPRESS. i tried to convert an "ACCESS" database to sql and got the next error:
: "AN ERROR OCCURED WHILE ESTABLIDHING A CONNECTION TO THE SERVER. WHEN CONNECTING TO SQL 2005, THIS FALIURE MAY BE COUSED BY THE FACT THAT UNDER THE DEFAULT SETTINGS SQL SERVER DOES NOT ALLOW REMOTE CONNECTIONS. PROVIDOR NAMED PIPES ERROR 40 - COULD NOT OPEN A CONNECTION TO SQL SERVER".
caution: this is not doubt a stupid newbie question...
In creating vs.net 2005 website, I can add a sql database to my project and a mdf file is created. I can create data providers against this file, etc, just as though it were a database in a sql server instance. I can deploy this dbf file to my finished web site.
Also, I can attach to a running instance of sql server 2005 express, and do exactly the same thing.
I can also take my mdf file created in step 1 above, and attach it to a running instance of sql server express.
Now, I have delt with access databases, and sql server 2000 databases, so this dual nature of sql server 2005 express confuses me a little.
Why would I ever need to use a server instance of sql server 2005 when I can use a file based data file in my web apps? Is there an advantage to one or the other?
I had a thought that when using the file based method, I was actually still using the server based stuff, which would explain why the sql server express notification bubble pops up when I debug on the dev machine.
In any case could someone explain the difference and should I install sql server 2005 express on my deployment server?
If you're like me, you'll get the following error:
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource".
I'm trying to learn how to use the bcp utility... but I keep getting an error message that says: SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].SQLState = HYT00, NativeError = 0Error = [Microsoft][SQL Native Client]Login timeout expiredSQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]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. The command i'm running is: bcp territore.dbo.import in territorydata.csv -T -c territore is my database name... and dbo i think is the owner name. and the table is called Import I don't know how to check the default settings to see if remote connections are enabled. Any help would be appreciated.
My apologies if my question seems rather naive, but I'm looking for some info on how SQL Server (2K) calculates the GETDATE info. Is it from an internal algorithm of some type, or does it simply pull the info from the local server info?
Can someone help me to understand something about SQL Server? I will use Access for comparison.
Suppose you have a SQL Server database and you want users to be able to enter data into the fields just like you could with an Access database and forms. How would you set that up with SQL Server? I have noticed that you can convert an Access database into SQL Server, but you still need to use Access forms to enter data into the tables stored in SQL Server.
What if you wanted to create an SQL Server database from the ground up and set it up for user entry?
I have a legacy database in SQL 2000 which I want to submit transactions thru triggers to SQL Broker, until I eventually upgrade this db to 2005. Can you tell me if this is possible?
