SQL Server Newbie Question On Permission
Jan 9, 2007
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
View 1 Replies
ADVERTISEMENT
Dec 13, 2005
I have an application that uses Integrated Windows authentication. My Web.config looks like below
<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />
When users try to access my application, they get the below error:
Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'
The Only way I could get rid off the error is if I set DBO permissions for the user group on the databse.
Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.
Thanks,
View 2 Replies
View Related
Feb 24, 2007
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:
[SqlException (0x80131904): Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.
Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735075
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.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
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?
Many thanks.
James
View 1 Replies
View Related
Sep 19, 2007
SQL Server 2005 anomoly?
In SQL Server Management Studio I granted specific permissions to user "A" to do Select, Insert, Update, Delete on Table "B" -
When I logged on as User "A" and attempted the Insert imto table "B" I got the following error:
"Insert Permission Denied on Table B, Database C, Schema dbo"
Is this a problem with the dbo schema?
Then I went back and created a stored proccedure "D" with the exact same Insert statement inside the procedure. I granted User "A" execute permission on the stored procedure "D".
I then logged on as User A and executed Stored Procedure "D". No Problem - stored procedure executed fine with the Insert.
I attempted the Insert statement again - straight SQL - as User "A" and got the same error as above ("Insert Permission Denied.....")
Strange behavior - cannot do a SQL. Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?
View 2 Replies
View Related
Apr 9, 2005
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.
Rgs
Ramu
View 1 Replies
View Related
Jan 3, 2000
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
View 3 Replies
View Related
Dec 21, 2004
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:
create table AGP_TYPES (
WL_AGP_TYPE VARCHAR2(4) not null,
WL_AGP_TYPE_DESC VARCHAR2(40),
constraint PK_AGP_TYPES primary key (WL_AGP_TYPE)
)
/
create unique index PK_AGP_TYPES on AGP_TYPES (
WL_AGP_TYPE ASC
)
/
create table ALARM_SYSTEMS (
WL_ALARM_TYPE VARCHAR2(4) not null,
WL_ALARM_TYPE_DESC VARCHAR2(40),
constraint PK_ALARM_SYSTEMS primary key (WL_ALARM_TYPE)
)
/
create unique index PK_ALARM_SYSTEMS on ALARM_SYSTEMS (
WL_ALARM_TYPE ASC
)
/
View 5 Replies
View Related
Mar 14, 2007
I am attempting to setup SSL with SQL Server 2005. I do not wish to have the domain account that is running the SQL Server Service be an administrator. What rights/permissions does this account require in order to start sql server with an SSL certificate?
I have tried putting the certificate in the local store but you need to be an admin to see it there. If I put the certificate in SQL Server Service account's personal store, I can't start sql server. "The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid." Is the error I get.
Thank you for your help.
View 13 Replies
View Related
May 18, 2007
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.
View 3 Replies
View Related
May 20, 2007
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.
Regards,
Anson
View 3 Replies
View Related
Jan 21, 2005
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?
Thanks
Martin
View 1 Replies
View Related
Jul 31, 2000
Good afternoon one and all,
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?
Thanks in advance for any and all help
Gurmi
View 2 Replies
View Related
Jul 31, 2000
Good afternoon one and all,
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?
Thanks in advance for any and all help
Gurmi
View 1 Replies
View Related
Mar 31, 2003
My previous experience is with php and MySQL.
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?
Any help appreciated
H
View 3 Replies
View Related
Nov 30, 2005
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???
View 14 Replies
View Related
Aug 7, 2006
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.
Any help would be greatly appreciated.
View 4 Replies
View Related
Apr 21, 2004
hi to all,
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...
MeCeX
View 1 Replies
View Related
Sep 30, 2005
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.
Help!
View 5 Replies
View Related
Sep 18, 2006
I'm confused by the MS literature. I think that "SQL Server Everywhere" is the new name for what was "SQL Mobile". Am I correct?
TIA,
barkingdog
View 1 Replies
View Related
May 23, 2008
I have a custom made database role that has permissions to execute a stored procedure. The store procedure then selects data from some tables. But the role does not have select permissions on the tables. Do I have to allow select on the tables, or can I do this another way?
View 2 Replies
View Related
May 14, 2008
Hi
I need to add a linked server .I am able to add it using SA account however if i use any other account i am unable to do so.
My question is what permisson does a ordinary user requires to add a linked server .
regards
Hrishy
View 3 Replies
View Related
Apr 19, 2007
Lets say i have a database user usrJohn. I have a set of views i want John to see, but i don't want him to be able to see the query that builds that view, but i want that view to show up in his View list. how can I make that possible?
View 9 Replies
View Related
May 12, 2007
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.
View 4 Replies
View Related
Apr 9, 2001
Hi!
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?
Thanks a lot.
View 1 Replies
View Related
Aug 29, 2006
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?
View 3 Replies
View Related
Dec 19, 1998
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
View 1 Replies
View Related
Jun 10, 2004
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
View 2 Replies
View Related
Nov 23, 2004
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.....
Thanks again,
James
View 3 Replies
View Related
Feb 1, 2005
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?
Thanks
View 6 Replies
View Related
Feb 28, 2006
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.
Thanks for your help.
Steve
View 1 Replies
View Related
Sep 7, 2007
Hi,
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]
View 2 Replies
View Related
Sep 27, 2007
hy.
i am a newbie to SQL
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".
any help apreaciated.
View 1 Replies
View Related