Acess On Production Server

Jul 12, 2007

Hi,



Presently our Organisation is in process of Implementing SOX.

Under Compliance all the User have to be removed from the Production Server.



1.My Question is Do a DBA Should have Admin Privilages on the Production Server.

If yes then what are the Actitvies that a DBA has to perform only if DBA have admin privilages.



Regards

Sufian





View 2 Replies


ADVERTISEMENT

Convert MS Acess To SQL Server

Apr 21, 2007

if (!Page.IsPostBack)
{ if (Session["users"] != null && (Session[flag"] == "true"))
{
      String IP = Request.ServerVariables["remote_host"].ToString();
      String Datee = DateTime.Now.Date.ToString();
     OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source="
                                                                              + HttpContext.Current.Server.MapPath("~/App_Data/result.mdb"));
     OleDbCommand cmd = new OleDbCommand("Insert Into KullaniciSayisi (IP,Datee) Values (IPDatee)", con);
    cmd.Parameters.AddWithValue("IP", IP);
   cmd.Parameters.AddWithValue("Datee", Datee);
   con.Open();
    intresultt = cmd.ExecuteNonQuery();
   con.Close();
    Session["flag"] = "false";
}
}
I want to convert this code to SQL sever . However I can not do it? Can you help me?

View 7 Replies View Related

Problems To Acess Sql Server

Apr 4, 2006

Using Web Matrix I made and tested a query using the Sql wizard acessing a SQL server table and it worked fine.
Web Matrix created the following connection string, in the function to create the query :
"server='(local)'; trusted_connection=true; database='AVAL_360'"
But when the function created to execute the same query,my application then the following error showed up.
Login failed for user
What is the matter ?
Can someone help me ?
Thanks in advance
 
 
 

View 1 Replies View Related

How To Send Data From MS Acess To SQL Server 2005

Apr 29, 2008

Hello,

I mistakenly deleted my source table data.

Now i want to again migrate the data from MS Aceess table to the SQL server table.

Please tell me

As far as i remember I used some export or import command.

Thank You
please dont send me link...i have to do it now so no time to read

View 1 Replies View Related

Paging: SQL Syntax For Acess Versus SQL Server 2005?

Feb 7, 2008

Hi,
I'm using ComponentArt's Callback grids with Manual Paging.

The CA example grid uses Access:(http://www.componentart.com/webui/demos/demos_control-specific/grid/programming/manual_paging/WebForm1.aspx)

That SQL syntax produced is invalid in SQL Server 2005.

Example:
"SELECT TOP " & Grid1.PageSize & " * FROM (SELECT TOP " & ((Grid1.CurrentPageIndex + 1) * Grid1.PageSize) & " * FROM Posts ORDER BY " & sSortColumn & " " & sSortOrderRev & ", " & sKeyColumn & " " & sSortOrderRev & ") ORDER BY " & sSortColumn & " " & sSortOrder & ", " & sKeyColumn & " " & sSortOrder

So...This is what I have (simplified), and it appears return incorrect rows on the last few pages:
SELECT top 15 * FROM Posts where & sFilterString & " and Postid in (SELECT TOP " & ((Grid1.CurrentPageIndex + 1) * Grid1.PageSize) & " Postid FROM Posts where " & sFilterString & " ORDER BY " & sSortColumn & " " & sSortOrder & ") " & " ORDER BY " & sSortColumn & " " & sSortOrderRev


What other approaches has anyone used besides the "ID in (...)"?The examples I have included show the available variables: sort asc and desc, current page, number of rows on a page, etc.

View 2 Replies View Related

Export Wizard Disturb The Order Of Data While Exporting Data To Acess 2003 From SQL Server 2005

Feb 24, 2007

 
I am using the following query to export data from sql server to ms access in export data wizard:
 
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
 
This query will fetch about 7, 00,000 records.
 
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
 
Please give me the solutions.

View 4 Replies View Related

Sql Acess

Dec 6, 2007

Hello,
We are using SQl as the DB for our application. Now we lost direct acess to the DB, but we can acess through the application.
How we will get the direct acess back? The network side is ok.
We don't know how it happened. can anybody help me to resolve this?

View 4 Replies View Related

Why Do I Get Acess Denied

Apr 25, 2004

Hello.

Im trying to insert data in a sql-table using a SP.
But it wont work!

here's my connectionstring (established in Page_Load()):

sqlconCon = new SqlConnection("server=localhost;database=dbJonas;Trusted_Connection=Yes");

and it executed like this (in a OnServerClick-eventhandler):

SqlCommand sqlcmdInsertNewsArticle = new SqlCommand(insertCmd, sqlconCon);
...
filling with parameters
...
sqlcmdInsertNewsArticle.Connection.Open();


The error I get point to the Connection.Open()-line and says :
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

does anyone know what I may have done wrong?

I have other connections to the server that works fine (Select-statements though)

anyone? thankful for tips...

View 2 Replies View Related

Acess I/O File

Jul 20, 2005

Is it possible to access a file (for example, to write in a text file)with transact-sql?.I've create a stored procedure and I'd like to write in a log filesome traces depends on the result of the statements executed in thisstored procedure.Thanks

View 1 Replies View Related

Acess Tables From Different Databases

Jan 23, 2008

I am using Vista Business with Visual Web Developer and Sql Server Express 2005. I want to be able to access the data from two tables in a query. Both tables are attached to the application. 
To refer to the two databases I have used the following
DATABASE.OWNER.TABLE (specifically TaskMgr.dbo.TaskTable)
For both databases I get the error  "Invalid object name"
What am I missing?
Thanks

View 2 Replies View Related

Data Acess Class

Jul 11, 2004

hi
i was reading book about asp.net and i found example for a dataacess class but i didn't understand this part

Private m_FieldData As New NameObjectCollection
Private _m_ConnectionString As String
Private m_dbConnection As SqlConnection
Private Sub AddParameters( _
ByVal objCommand As SqlCommand, _
ByVal objValues() As Object)

Dim objValue As Object
Dim I As Integer
Dim objParameter As SqlParameter

objCommand.Parameters.Clear()
SqlCommandBuilder.DeriveParameters(objCommand)

I = 0
For Each objParameter In objCommand.Parameters
If objParameter.Direction = ParameterDirection.Input _
Or objParameter.Direction = _
ParameterDirection.InputOutput Then

objValue = objValues(I)
objParameter.Value = objValue
I = I + 1
End If
Next
End Sub

Private Sub AddFieldParameters _
(ByVal objCommand As SqlCommand)

Dim objParameter As SqlParameter

objCommand.Parameters.Clear()
SqlCommandBuilder.DeriveParameters(objCommand)

For Each objParameter In objCommand.Parameters
objParameter.Value = _
_FieldData.Item(objParameter.ParameterName. _
Substring(1))
Next
End Sub
Public Function ExecDataReader _
(ByVal strStoredProc As String, _
ByVal ParamArray objValues() As Object) _
As SqlDataReader

Dim objCommand As SqlCommand
Dim objReader As SqlDataReader

objCommand = New SqlCommand

objCommand.CommandText = strStoredProc
objCommand.CommandType = CommandType.StoredProcedure
objCommand.Connection = dbConnection

Try
objCommand.Connection.Open()
If (objValues.Length = 0) Then
AddFieldParameters(objCommand)
Else
AddParameters(objCommand, objValues)
End If
objReader = objCommand. _
ExecuteReader(CommandBehavior.CloseConnection)
Catch ex As Exception
If objCommand.Connection.State.Open Then
objCommand.Connection.Close()
End If
End Try

Return objReader
End Function
can anybody help me what the author want to do

View 3 Replies View Related

Still Can Not Acess Database. Help Needed. Thanks.

May 29, 2001

View 1 Replies View Related

DB Acess Slowing Down Drastically

Jun 3, 2003

hello,
i am getting a problem

suddenly the DB in Sql2000 has slowed down drastically
and when i have checked the logs the error is

Supersocket info:[spn register]:error 1355

pls. help me

pavan

View 2 Replies View Related

How To Connect To Acess Databaseto Another PC?

Jan 17, 2008



1) I have two PC. PC A and PC B.

2) I have one Access database in PC A in the folder of C:TEMP

3) I have a website done using a visual studio in PC B.

Question is how do I connect the website in PC B to the Acess database (C:TEMPdata.mdb) in PC A??

Thanks in advance. really need some help cos I have really no idea to that, i'm really new.

If possible,give me in steps

View 5 Replies View Related

Unable To Acess Database In Webpages.

Jun 8, 2007

 Hello,I am unable to access SQL Server 2005 (Express Edition) when i am creating wesites on localhost.But the same database can be accessed without any problem when websites are created on local file system.When creating the website on localhost and trying to access databse the following error is displayed: "
Failed
to generate a user instance of SQL Server due to a failure in starting the
process for the user instance. The connection will be closed."Anyone plz help me out of this? Thanks.Ashu. 

View 13 Replies View Related

Database Acess Logscan Error

Aug 20, 2006

HI all,

I currently have an issue trying to access my database in SQLexpress2005. Whenever i try to start the service it errors out. I looked at the error in event viewer and it says says
"The log scan number passed out to log scan in database 'master' is not valid. This error my indicate data corruption or that the ldf does not match the mdf....."

How can i fix this problem seing as though i can not access studio manager to restore the db?

Brad

View 1 Replies View Related

Permission Acess The Share Folder.

Jun 22, 2008

hi. i got a question regarding the permission on share folder.
i wonder i am able to do this as below..
if on runtime, after i export the data to xmlfile and i want it to auto save into the SHARE Folder in sql server. can i do that ?

** after press a button, auto export data to xml file, then auto save the xml file to share folder.

View 3 Replies View Related

Global Groups, Schema And MS Acess

Jan 17, 2007



Hi,

We have a MS Access .adp app which is having some security problems. We have a windows global group which is a user - which is added to a role. The developers are having problems with unqualified sql statements trying to find user.table instead of dbo.table. It seems we are not able to specify a default schema for the global 'user' - the option is greyed out and a sql statement fails. MS says:
Default Schemas


A default schema is used to resolve the names of securables that are referred to without their fully qualified names. In SQL Server 2000, name resolution first checks the schema owned by the calling database user, followed by the schema owned by dbo.

In SQL Server 2005, each user has a default schema. The default schema can be set and changed by using the DEFAULT_SCHEMA option of CREATE USER or ALTER USER. If DEFAULT_SCHEMA is left undefined, the database user will have dbo as its default schema.







Is the default truly undefined in a global group user? We are not totally locked in to the global group solution, but it does make admin easier for us.

Thanks a bunch!

View 3 Replies View Related

Acess Denied Starting MSDE 2000

Aug 6, 2007

Hi

We have a demo version of our SQL2000 application that uses MSDE. This has always worked sucessfully in the past.

However, at the most recent installation however there is a problem which I cannot seem to fix.

MDSE was installed on Windows 2000 using the Local Admin account.

When the user logs on to the PC, SQL will not start gives error message '5 Access Denied'.

I have given the local user read/write permission to the Data directory and mdf/ldf files that it contains.

I have tried starting SQL specifiying it to log on using the Local Admin account but it makes no difference.

Does anyone know what else can I do?

Thank you

Mark

View 4 Replies View Related

Sql Server 2005 Full Text Search Not Working As Expected On Production Server

Jan 28, 2008

I have this simple full text search query that works perfectly on my own computer using sql server 2005 express, however, on the production server(shared hosting)when I added the first 50+ rows,  the full text search works perfect, but as the number of rows increases,  the full text search can only see the first50+ rows, but not the new ones. Is there any quick solution for this or it's just a common mistake for developers for not properly indexed columns?Is there a way to re-indexed all rows without loosing data on the live server? search query: SELECT TOP 50 *FROM li_BookmarksWHERE FREETEXT(Keywords,@Keywords)       

View 2 Replies View Related

How To Setup A Backup Server For SQL Server2005 For Production (in Case The Primary Server Fails)

Aug 1, 2007

I currently have a SQL Server cluster setup with a Primary DB Server SERVER1 and the Standby server SERVER2. SERVER1 has been failing more than normal is the past few weeks and its takes upto 5 mins for SERVER2 realize that SERVER1 is down. I am looking for a better way to implement a backup server on production with minimum downtime. Please adivse..

View 1 Replies View Related

SQL Server 2008 :: Import Table Data From Production To Development Server

Feb 18, 2015

Production and development servers are on different domains and they do not trust each other. How do I import data from the table t1 from a database db1 in production and load it into table t1 inside database db1 in development?

View 3 Replies View Related

Help Needed - How Can I Set Up A Backup SQL Server Machine As An Exact Copy Of My Production SQL Server

Jul 20, 2005

Any help would be greatly appreciated.My problem is that I need to set up a backup SQL Server 2000 machinewhich can be used in case of a failure to my primary. All databases(30 as of now) must be an up to the minute exact copy of productionand include most recent changes in data as well as any structurechanges (Tables, Views, SP's, Triggers, Users . . etc).When I tried this using Transactional Replication, the replicationprocess gets fouled up once I introduce any kind of structure changesto the DB. I've considered the idea of doing periodic backups andrestoring it to my backup SQL server, but this does not give me theconcurrency needed with 0 latency.I've seen articles that recommend using Transaction Replication with'Scheduled Table Refresh', and also doing database dumps to restore onthe backup machine, but I have not been able to find any documentationregarding this to try out. How can I implement this type of backupstrategy in SQL 2000?

View 2 Replies View Related

How To Deploy Reports To Production Server, Do I Need To Have Sql Server Reporting Services Installed Or Just Runtime Files Ok

Apr 23, 2008



I would like to deploy several reports to production server, Do i need to install reporting services entire software in order to run the reports or is it possible to just have runtime files installed on it to run the reports.

please help, i have almost 100 reports to be deployed on this server which is located in other country.

Thanks for the helpful information.

(i am using SQL server 2005 / reporting services 2005.)

View 6 Replies View Related

Moving The .LDF On A Production Server

Dec 7, 2001

ok ok, stop laughing. for real, is there any programatic way of doing this? whom ever created this database i inherited (SQL 2000) created the LDF and DATA files on the same drive and in the same folder for that matter. just trying to do a little disaster magament.

thanks
matt

View 1 Replies View Related

Beta 3 On A Production Server.

Oct 14, 1998

This feels like a silly question, but I`m going to ask it anyway...

I have limited SQL Server experience, but have run into a wall with a client`s Web/Access combination. I need to upgrade to SQL Server. I have Beta3 installed on a development box and am very happy with it. Is anyone running this thing in a production environment? This isn`t going to be experience huge loads, so I`m tempted. Tell me if I`m crazy for wanting to try it.

View 2 Replies View Related

Copy Production Db To Another Server

Jan 31, 2007

I have a brand new database server with system databases.
I need to copy like four production database from another server to this new server. Can i do restore of the last production backups and restore them on the new server without creating the empty databases on the new server.If any one has better approach i will appreciate

View 3 Replies View Related

Production Server Issue

Apr 4, 2008

1.First issue
The port number already allocated was 2059. We have changed that into the default port 1433 in the node. Now we are able to connect the node from the client application. But we are not able to see the configuration manager in any of the environment now.


2. 2nd issue
Cluster Environment




Error while executing the Package The connection details are not loaded in the connection manager tag





The same error with advanced information.





Another error window





R.S.Moorthy

View 1 Replies View Related

Production Server Probs

Nov 9, 2007

I have production server 2000. The server gets disconnected sometime by itself and sometime it is working fine.Sometimes it even doesn't get restarted. Is there any problem with service packs and some performance issues.
Can you SQL guru give me best suggestion and how should i proceed.

View 3 Replies View Related

SQL Server On Production Very Slow

Jan 17, 2007

Hi,I ran test data on my development machine and it took 1 minute toinsert the data. Ran the same set of data on the server and took 5minutes.Check both database and everything is the same. I even copied theproduction DB on my machine and it was taking still about 1 minute.Look at the fragmentation, and all the numbers are better on the serverthan my development machine so it should be faster.In the application I put some timer and discover that the insert istaking 0.015 ms on the server and 0 on the development. So the problemis on the insert.It is a Web application using ASP.NET.Here are the spec of the computers:Development: P4 HT 3.2GHz 1gig memory running WIN XPServer: Xeon 2.8GHz 1.5Gig memory running WIN 2000 serverAny idea how I to pinpoint the problem? I'm not at the point ofthinking that it can be the hardware, but how to verify that?ThanksFrank

View 2 Replies View Related

Usage Of CLR In Production SQL Server

Nov 6, 2007

Like most enterprise there is the database administrator (dba) and there are the developers(dev). The dba are conservative while the developers are also exploring their options.

One of the current usage I'm experimenting on is to provide data visualization - image for the data. Like most I needed to "create" the System.Drawing assembly in the database, marking it unsafe.

During my testing, my code had some exception and that brought down SQL Server.

I read that the CLR is better compare to the sp_OAs as well as the extended stored procedures written in C++ because it isolates the execution in a separate app domain and termination is clean - in case of any errors, it should not bring down SQL Server.

Also I read marking assembly unsafe void these benefits of isolation.

Instead of having to manage the situation where it involves code review by the dba and asking the dba to take some risk, is there a technique where all CLR code that runs in the production server does not pose stability issues.

View 1 Replies View Related

SP2 On Running Production Server?

May 27, 2007

How can I apply SP2 on running production server if SP resets all protocols (from TCP/IP enabled on production server to Shared Memory enabled) without disrupting its connections and thereafter its work?

View 1 Replies View Related

Auto Restore .bak From Production To Same Server's TEST Db With Other Dbs && .baks In Same Server.

Aug 10, 2007



Howdy;
I've tried this in the 'tools' area, but that didn't work too well. I suspect, I will have to generate a T-SQL code then schedule it as a job. Why I can't just drag and drop with basic desires, is beyond me, but THAT probably does exist.

anyway here is the problem
[this server has many databases, on SQL 2000 sp2]
1. User only wants me to use Monday morning's full backup, which is good in that it doesn't include transaction logs.
2. Restore that data overtop/into Developement db. = good, no data to worry about damaging.
3. User does NOT want me to do this by hand, but schedule it.

ok,
a. must do a RESTORE WITH FILELISTONLY from [?] what ?, master? and if I user the *.bak of the production, it has
a coded date field in the name entry SO, I would, I guess, have to generate all sorts of wonderful code to find the date and build a file name. Why, because using the FROM DISK = 'F:MSSQLBACKUPDBPRODUCTION_yyyyddmm.BAK' is not going to work with a wild card.
Can I do a file lookup using a 'PRODUCTION' prefix into a variable, then use that or should I look for latest file date [remember there are several database backups here], or ????

then. How does one schedule such a T-SQL. Do I save it to some text file, and invoke it using a job scheduler.

any help appreciated.

IS there an easier way.
rik

View 5 Replies View Related







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